AnsweredAssumed Answered

Show last modification (cross tables)

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


Show last modification (cross tables)


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,