You can create the audit table so that it exactly matches the structure of
the query instead of a table.
That might not be so useful, of course: if the fields that are updated are
drawn from more than one table, you might have partial auditing of disparate
tables.
Do you mean does it work if you update the table through a query, as opposed
to through a form?
I don't believe so.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
