Create new record in related file on field change
System: FM Pro 9 Advanced shared on OSX & Windows.
I have a database for a costume hire business. Customers are able to take a costume immediately, or leave a deposit & pay the remainder later when they collect the costume.
I need to be able to generate an accurate printout of daily takings on a regular basis for our auditor.
I would like to be able to automatically generate a new record in an Activity Log whenever an invoice is created or has one of a number of trigger fields altered. I've created an Activity Log and related it to Invoices, but can't get the relevant invoice data (Deposit, Hire Amount) into Activity Log fields.