I'm using FMP 17 Advanced. I have a child table with looked up values from a parent table. When data from the parent table changes, I want to relookup the data and update the corresponding child data. I have written a script to execute this successfully. My problem is, the script is triggered by "OnObjectSave" for the field in question. This causes my script to trigger even when the user is entering a new record versus editing an existing record (with associated data in the child table)...
I changed the trigger to "OnObjectEnter" to allow me to test for whether the record is a new or existing record, but I don't know how to do that and still allow the user to update the field value. Any ideas would be most helpful.