Hi Ronald,
I'm developing a system that uses triggers to create audit trail records on a few critical tables. Whenever someone updates any of the data (in this case I'm only concerned with the Update trigger), whether it be from my shiny new edit screen, directly using foxpro or from another system, the audit trail records are written to the audit trail table.
Jason
---------
Single field, surrogate primary keys....because it's sexier!
Third normal form is more than just a good idea.
