Automatically Update a Second Table

[JD McLeod]

I have a table with audit steps to be performed. The primary key in this
table is the audit step reference “G01â€, “G02â€, etc. The first table
contains all the details of the audit step such as the frequency to be
performed, etc. I have set up a second table to be used for entering the
results of audit testing. What I envision is to have the second table
automatically update for the audit step reference when a new audit step is
entered into the main table’s data entry form. Only the audit step reference
would update. The user would then use other forms to update the results of
testing. How would I get the second table to automatically update for
additions and deletions from the primary table? Would I have to use append
and delete queries? Is so, I am not that advanced in Access and may need
some additional thoughts on how to set up this database. Thanks.

 

[Duane Hookom]

If I understand your table structure correctly you may need to use append
and delete queries. The At Your Survey demo app at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane has an
append query that might be similar to your system needs.