Automatically Update a Second Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
JD said:
I have a table with audit steps to be performed.

How would I get the second table to automatically update for
additions and deletions from the primary table?
Click to expand...

You could use foreign keys (ON CASCDE CASCADE) to ensure values are the
same in both tables, however, considering the referencing table would
be in the same database and 'hard-wired' to the values in the
referenced table, I don't see how this can be considered an 'audit'.

You could create a view ('stored query') that joins two tables, which
could even be in separate databases, where updating the view would
update the respective base tables; again, I'm not sure if this can be
considered enough separation for audit purposes.

Jamie.

--
 
Back
Top