AnsweredAssumed Answered

update customer with latest invoice date

Question asked by staffordavid on Feb 17, 2016
Latest reply on Feb 17, 2016 by staffordavid

This has got to be easy, and I am just being obtuse.  My customer table is related to my invoices table, of course.  I think I can design a script that would update a customer record with the date of the customer's latest invoice, but I'd like to have that information automatically applied to the customer.  There must be a calculation I can use.  Anybody want to share that with me?  Thanks.


I'm using FMP 10.