Hi Rixon,

>Can triggers do this instead? In other words, if a field is changed, can it trigger an update to a remote table that needs to be kept in sync? If so, what would that trigger look like?

[SET BLATANT MARKETING ON] < g >

You might want to save yourself a ton of time and trouble by checking out FoxAudit from my company, TakeNote Technologies (www.takenote.com). It quickly and easily adds complete audit trail support, including the ability to roll back changes to a specified time and date.

Price: $259 (includes royalty free distribution rights and complete source code)

[SET BLATANT MARKETING OFF] < g >

Just a thought...