I noticed two other issues in relation to the audit trail code that need resolution.
1) if a feild is blank and then i enter a name, the code does not pick up the new entry. for instance, in my form, if the field business_unit is blank and then i enter card services in that field, an entry does not appear in the audit trail table. only changes to existing data are there. i need both to be captured.
2) the user id (is not being captured in the audit trail table.
A third issue that may need to be set up as a separate issue. I want this audit table to also capture new entries into my form.