Re: FMP 9 Newbie - Relationships "Through" Related Tables
- From: Howard Schlossberg <howard@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 26 Apr 2008 12:23:51 -0700
So you are running a report from a special Reports table, and you have the relationship from the Reports table (one to one) to a single People record and (one to one) to a single Zip Code record?
Assuming both relationships are valid (i.e. there is a valid PeopleID in Reports to People, and there is a valid ZipCode from People to ZipCodes), then there is no reason you shouldn't be able to see the zip code's city from the Reports table.
What do you get when you do this? Blank? Or the wrong city?
Peter Sturges wrote:
I read somewhere that you can "tunnel through" tables for relationships..
Say I have a zip code table, a People table and a Report table (just a bunch of Unique IDs and Zip codes) all in a "straight line".
Obviously I can pull related data from the People table, but I can't see how to "tunnel through" the People table (related by Unique IDs) to the Zip Code table (related by Zip Code) to say, put the city on that report.
- References:
- FMP 9 Newbie - Relationships "Through" Related Tables
- From: Peter Sturges
- FMP 9 Newbie - Relationships "Through" Related Tables
- Prev by Date: Re: validation scripting
- Next by Date: Re: 4 Records to a layout page: printing
- Previous by thread: Re: FMP 9 Newbie - Relationships "Through" Related Tables
- Index(es):
Relevant Pages
|
|
