For my upcoming project I want my database in access2007, to have a particular field updated across say 4 tables.
For instance I have field called product_code in one table, so when I update the record in this field it will update all the tables in the database that have the field name product_code of the same record.
How do I achieve this, hopefully i have made sense?
You need to establish relationships between the tables and enforce referential integrity.
Good explanation and how to at