Select fields from Last Row in a portal
This is an adaptation of the Business Pack Services Edition of FMP 9 Adv.
In the "Contacts" Table "Contact ID" Indexed Field and used in a relationship with "Service Orders" table field "Bill To"
In the "Contacts" Table I have a field called "Last Service Ordered Date"
In a separate file and table "Service Orders" I have "Sale Date"
I would like to automatically (calculation) fill the "Contacts::Last Service Ordered Date" with the LAST "Service Orders::Sale Date"
I started thinking about this:
"Service Orders::Sale Date" is present on my Contacts Main Layout via a PORTAL and the last service to this client is the last row in the portal.
Conclusion: I have no idea how to have the "Contacts::Last Service Ordered Date" automatically replaced every time I create a new order to this client.
ANY suggestions are appreciated.