Button Command update multiple tables at once

[duecesup]

Hello Everyone,
My database center's on a unique identifier in a table called tblSDAC. This unique identifier is located as foreign keys in 3 other tables. to ensure data integrity I need to update all these tables simultaneously when I enter a new record in my data entry form. I have created a command button to run an append query "On Click" I would like to include additional tables to the append query to update all tables at the same time. The append query wizard only allows one table at a time. How would I do this?

The other tables are called tblSiteComponents, tblSiteRecord, (and) tblCRM

Thank you for your assistance

 

[pono1]

Wrap three append queries, one for each table, into a single transaction. See BeginTrans and Transaction in the Help file or google something like MS Access BeginTrans Transaction Statement. You should be able to find code samples. Give it a try and post back with any problems...

Regards,
Tim