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...
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development