AnsweredAssumed Answered

Show last modification (cross tables)

Question asked by FredH on Oct 31, 2014
Latest reply on Nov 1, 2014 by FredH

Title

Show last modification (cross tables)

Post

Hi Experts,

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!
Kind regards,
_Fred_

Outcomes