How to use most recent sale date for a given customer in a calculation?
Using the example of a Customers table and an Invoice table...
I would like to have a "reminder" date field within the Customer's table for the date 6 months from the last sale to that customer. The two tables would have a relationship based on the customer's ID.
How would I setup of calculation in the "reminder" field to look in the Invoice table for the most recent invoice date for a given customer, and add six months to it? (I do know how to add 6 months to a date)
I would appreciate any guidance...