Any time you refer to data from a related table and there is more than one related record, you get data from the first related record. In an unsorted, unfiltered portal, that's the same record as that shown in the first portal row. To refer to data from a related record, you'd need to take specific steps to refer to that specific record.
- A relationship can match to that one specific record.
- The Last() function can return data from the last related record.
- GetNthRecord can refer to the Nth related record.
thanks phil you are the best ! i was missing Last (field) and it was stuck in just one portal