When a user clicks on a button on a form for the Product Line Items database, the following script is run:
Set Error Capture [ON]
If ["Status(CurrentFoundCount) > 1"]
Delete Record/Request [No dialog]
Show All Records
I want to add functionality to insert a record into the AuditTrail.fm5 database before the Delete Record/Reques [No dialog]
line. I was first going to execute a SQL call, but am being asked to install the ODBC components before using FileMakers ODBC Import feature. Assuming my client no longer has his original install disks (I'm working on a spare Macbook he provided"), how can I do this with native commands?
This is an urgent request. Thank you.