Auto run Update Query

[JazzTheMan]

I have 2 tables: MC Checklist(Child table) and RD Checklist (Parent table). They both contain a field named "Checklist Status". When the "Checklist Status" of the RD Checklist changes to 'Complete', I want the MC Checklist "Checklist Status" to also change to 'Complete'. I know I can do this easily with an update query. The problem I'm having is how to get the update query to run automatically when the RD Checklist 'Checklist Status' changes. These tables are connected to InfoPath forms, so the users never interact with the database itself, in order to run the update query. Any help would be appreciated!!! Thanks

:banghead:

 

[pbaldy]

Depending on version you can try a data macro. Frankly, you normally wouldn't have a field in one table that depended on another.