AnsweredAssumed Answered

Create Change History Records

Question asked by LeoCA on Dec 8, 2008
Latest reply on Dec 11, 2008 by LeoCA

Title

Create Change History Records

Post

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

SELECT *,user_id,SYSTEMTIME

FROM invoices

WHERE invoice_ID=...

 

OR, any idea of implementing similar feature in FileMaker.

 

Thanks.

 

LeoCA

Outcomes