use a portal with one row and sort it in decending order of recordnr.
Thanks for your quick reply.
A portal works great when in Form-view. The reason why i want it in a lijst or table-view is that the user should be able the view/export these records to Excel.
You can also specify this sort order (descending order of Recordnr) in the relationship and then you can add the fields directly to your layout without using the portal. Either option works and both methods have their uses.
Both Mark and I are assuming that recordnr is an auto-entered serial number field.