Hi List, I thought this behavior was a bit weird:
If you setup auditing on a join form as per the documentation, and you set some fields on BOTH underlying forms to "audit and copy".... I would expect that any fields on either form, if edited, would trigger an audit on BOTH forms (because they are joined). As it turns out, the joined audit only seems to get trigged when the Primary form (in the join criteria) is triggered. Does that make sense? I want to capture ALL audit+copy fields from both forms into the audit table if even ONE of the trigger fields is modified on even just one form. As it is now, that happens but only if the triggered field is in the primary form in the audit join! Thanks for any ideas ARS 7.1 patch 003 mssql 2005 Brien _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"