Colin:
This is indeed a limitation with Filemaker, but it can be overcome
using an intermediate "join" file.
I won't go into the technique here, (unless there is sufficient
demand to do so), but it is covered in several sites and publications
that discuss more advanced Filemaker programming techniques.
bob
At 6:44 PM -0500 11/2/00, Colin Cooler wrote:
>Not a direct question regarding ebase, but kind of related (ahem):
>
>I have three files linked via relationships in the following manner:
>
> File A (Clubs)--> File B (Members) --> File C (ebase)
>
>"File B" displays basic ID information (i.e., name) from "File C" and also
>adds additional demographic info to this (student ID, age, race, sex, school
>attendance/history, etc) as well as associating each record with a
>particular club.
>
>File A "marries" the information in File B with infomation on Volunteers (in
>another file) and displays all club participants (members and volunteers) in
>two portals (side-by-side).
>
>I thought that I would be able to display the "name" shown in File B within
>File A, but I cannot. In other words, I can only display related
>information ONE FILE AWAY! I knew that this was a limitation in FMP with
>CALCULATIONS that depend on a relationship, but these are simply text files.
>Of course, I could make the "name" field in File B a LOOKUP, but this sort
>of diminishes the value (i.e., decreased file size) of using related files,
>doesn't it?
>
>Ultimately, I will merge all info in "File B" directly into ebase (File C),
>so this will become a moot point (I am keeping them temporarily separate
>because I may be obtaining this student information from the local school
>system's database, and wanted a "temp" file to dump this info into before
>importing into ebase). It is disconcerting to realize, however, that I can
>only utilize the relational concept ONE FILE AWAY in FMP!
>
>Am I missing something, or is this, in fact, a limitation of FileMaker Pro??
>
>Tanks Expurts,
>Colin
--
-----------------------------------------------------------------------------
Bob Schmitt, TechRocks
38 South Last Chance Gulch - Suite 2A Helena MT 59601-5029
Voice: 406.442.3687 Email: [EMAIL PROTECTED]
eFax: 520.832.1047 Web: http://www.techrocks.org
----------------------------------------------------------------------------
ebase� - Free relationship management software for nonprofits
http://www.ebase.org
-----------------------------------------------------------------------------
Gravity can be your friend.
