CODEWITHSUNDEEP
databasems-access
user333102
user333102

Reputation: 19

MSAccess: How do I create a form with a field that updates multiple tables that share that field?

I have a database that currently has 5 tables. Each table is linked by the Primary Key field, "Lot #", with each table containing data in a different category related to those lot numbers. I currently have forms for each of these tables that allow for the entry of the various data, but I would like to set it up so that new lot numbers are only entered on the form for the "Manufacturing Table", and then that data is auto-populated into the Lot # fields of the 4 other tables.

Is it possible to set up a form in this manner?

Upvotes: 0

Views: 57

Answers (1)

Johnny Bones
Johnny Bones

Reputation: 8402

Why do it in a form when you can do it in the database? Just set up relationships for the tables (linking on Lot #) and then set them up for cascading updates.

See Microsoft's KB and particularly the section about cascading updates and deletes.

Upvotes: 0

Related Questions