3 Replies Latest reply on Feb 17, 2016 9:18 PM by staffordavid

    update customer with latest invoice date

    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.

       

      David