I read somewhere that you can "tunnel through" tables for relation****ps.
Say I have a zip code table, a People table and a Re****t 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
re****t.
In FMP 6 and earlier, you would have to have bring the City over to a
field in the People table first.
Is this done with a multiple element relation****p...?
Thanks
Peter