Hi Everyone

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?