Change all related records
Hello! I am newly converted from the ms access world. I have put together a database to house all our inventory at our business. I have setup a table to store the inventory as well as a table that holds our employees. My end goal was to have the inventory entered as well as the current user of that inventory. So far everything is working great, but if I were to go into my employee table and change a user, someone left and a new hire was put in their place, it does not change the existing records in the inventory's employee field. The current relationship between the two tables is Inventory:User = Employees:Employee. I am still very new to creating databases, I only created one with ms access and it was a pain. I appreciate any help you can provide. Thank you!