Solved

FileMaker: GetNthRecord related field of a related row in a portal

Posted on 2014-04-18
2
1,269 Views
Last Modified: 2014-04-18
Hi Experts,

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:

people
person_id, name, address_id

addresses
address_id, address, state_id

states
state_id, state_name

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 )

it works.

Any suggestions?

Thanks
0
Comment
Question by:rmartes
2 Comments
 
LVL 5

Accepted Solution

by:
Peter Harris earned 500 total points
Comment Utility
One option:
In Addresses table create a calculated field (say called c_state_name) that holds states::state_name (based on a relationship between Addresses and States by state_id.

Make sure this is working, then you can use:
GetNthRecord ( addresses::c_state_name; $rownum )
0
 

Author Closing Comment

by:rmartes
Comment Utility
Perfect!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now