Hello Filemaker users,
When I have an unfiltered and unsorted portal I can see more than 1 related records. When I use GetNthrecord (fieldname ; 2 ) I only see the first record.
What am I probably doing wrong?
In portal setup you can specify initial row and number of rows to get only one row.
What do you expect?
I would like to show multiple photo's from a related table on the parent table. I would like each related photo to be in its own portal for resizing purposes.
If that's what you want you are using the wrong function. The purpose of GetNthRecord is to get a value from the field specified and the recordNumber specified. Your calc: GetNthrecord (fieldname ; 2 ), assuming fieldname comes from the related table will return the value from that field from record number 2 of that table. Further, note that when getNthRecord is pulling data from a related table, the record it regards as number 2 is based on the sort order of the relationship—and this means that if the relationship is unsorted, it will probably be the second record created. (See FM Help: FileMaker Pro 16 Help )
Retrieving data ...