Accessing related data from a third file

[M.A]

Hi all,

Can anyone tell me how to access related data from a third file. I have a file A which is related to file B. And file B is related to file C. Now, I have to access information stored in file A from file C. How can I do that without having to create 'calculation fields' in file B and then using those fields as related fields in file C ?

Thanks in advance !

Version: Developer v6

Platform: Windows XP

[CyborgSam]

Read CobaltSky's excellent paper on matrix modeling, look for "Matrix Data Modelling techniques in FileMaker Pro" at this link:

http://www.nightwing.com.au/FileMaker/resources.html

[Vaughan]

Or get FMP 7.

[M.A]

Wonderful, the Matrix data modelling techniques are great. They work like a charm. Thanks so much CybrogSam.

I am also planning to get FMP 7 as soon as they release it.

Thanks.

[CyborgSam]

FM7 has been released, many of us have been using it. Do you live someplace where FM7 isn't available for purchase yet?

[M.A]

Sorry, I meant FM7 server. Presently, I have FM6 clients and FM 5.5 server. And i dont think that fm7 works with FM 5.5 server and FM 7 server does not work with FM 6.0 clients.

[DaleGaumer]

Brute force technique that worked for me. Your file B is a join file for me. The join file B has calculation field "Conductors" with calculation "Session::Conductors", referring to file A. The same join record has another calculation field "Composer Last Name" with calculation "Composition::Composer Last name", referring to file C. Then file A can read "Composer Last Name" from file B, and file C can read "Conductors" from file B.