I have a field which is called 'DatePaidTo' in my 'Invoice' table and it is effectively the most recent date an invoice has been paid. A customer will pay monthly and his invoice record will show customer ABC paid up until the end of the month.
When I show the 'DatePaidTo' field on his record it only finds the first record. I want the field to display the most recent entry. I'm assuming I can use Conditional Formatting but a unable to find a formula. Any suggestions please?
I'm using FM Pro 14