FileMaker: GetNthRecord related field of a related row in a portal
Posted on 2014-04-18
So I'm having a little issue retrieving the value of a related field of a related row in a portal.
I have 3 tables with the following relationships:
person_id, name, address_id
address_id, address, state_id
I have a layout based on the people table with a portal based on the addresses table that shows all addresses for one person.
I'm trying to get state_name of the nth portal row in one of my scripts:
GetNthRecord ( states::state_name; $rownum )
but it doesn't work. I'm getting nothing. If I do:
GetNthRecord ( addresses::address; $rownum )