List that shows only the last record of a child record
I have a main table containing fields like Clientnr., Clientname, Address
and a child table containing the fields: Clientnr., Order date, Order Article, Price
I'm trying to create a new Layout (a list or table view) that has all records from the main table and only data only last record (highest recordnr) from the child table.
Is there a quick solution?