Show last modification (cross tables)
I have 2 tables (Customers & Invoices) which are linked. For each table, I have created an automatic (timestamp) field named _ModifDate.
I would now like to show the latest Modification Date (customer & invoices combined for the specific customer) on the customer form. I would also like to format the modifdate as a date rather than as a timestamp knowing that I show the ModifDate in a regular text field.
Any idea how I can do this?
Thanks in advance!