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.