Calculation to return most recent contact date for customer
I'm attempting to design a contact management solution. Most of it is coming together. The basis is each customer has multiple contact dates (with related notes) in customer and contact tables. I want to develop a calculation field that will determine when the last contact I made with a customer was.
I found the Get (NthRecord) and thought I could make that work. The calculation resulted in the earliest date in my contacts table...and it wasn't related to the proper customer.
Any help would be greatly appreciated.