AnsweredAssumed Answered

Create new record in related file on field change

Question asked by jgm_1 on Dec 16, 2009
Latest reply on Dec 19, 2009 by comment_1

Title

Create new record in related file on field change

Post

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. 

Outcomes