I have a form layout which has a portal showing notes from a notes table. When I switch to the table view and add the note field to the layout it shows the first related record from the notes table or the first note created for the current record. Is it possible to have it show the last record created? I am tracking an event and taking weekly notes and I need to export the data to Excel with the last note associated to the record for my users.
A good test is to create a new DB using the research notes template. Create a new record and then add a couple of notes to the record. Switch to table layout and add the Notes::notes field. By default it shows the first record in Notes that it relates too. And I need to show the last record it relates too.
Using FM Pro Adv 12