Dynamically add the primary key to related tables in Access
Posted on 2014-03-21
I have about 6-8 tables in an Access 2010 database that relate to the same primary key. Let's just say that all the tables relate to suppliers and SupplierID is the primary key in all the tables.
When I add a new record to the master table (ie add a new supplier to the Supplier List) I also want the ID to be added in all the other related tables and queries.
How do I do this and what's it called? Does this have anything to do with "cascade updating". Also, if I want to add a new table based on the list of all existing SupplierID numbers, do I have to export and re-import as a new table?
I know this is a rookie question. Thanks for your help.