Hi, Paul: As you've seen, in Table View, FileMaker will display the first record of related data. Portals (and their sort order) in layouts are ignored when in Table View. To display data from a different related record, for instance the most recently created, you need to use a relationship defined to sort, putting the desired record first. In this case, you would define the relationship to sort by serial number (inversed) or by creation timestamp (inversed).
Note, however, that when exporting, all the related records will be represented, not just the one record that displays in Table View. One workaround is to create a calculation in the parent table (the context from which you are exporting) for each field you need to appear in Table View and export. Such as,
Display_note [text] = CONTACT::contact NOTE
again, where the relationship "contact NOTE" is inversely sorted, so when Display_note is exported, only one CONTACT record is exported with its one NOTE record data.
I GOT IT! I GOT IT!
To show the most current note in table view I modified the current relationship to sort by the notes create date in descending order. BOOM...done
Then is used your field Display_note [text] = CONTACT::contact NOTE to allow exporting the one note.
Thanks Erik, you save my hide!