Create Change History Records
We want to insert records into a change history table (invoice_Chg_hist) every time a record gets changed on the target table (invoices). invoice_Chg_hist has all columns in invoices plus user_id and change_date columns. This can be done using Trigger on other database. Does FileMaker have Trigger feature? If not, can we execute SQL statements from scripts? I am thinking:
INSERT INTO invoice_Chg_hist
OR, any idea of implementing similar feature in FileMaker.