select from A to show B, select from B to show C

[Lougee]

As usual, this has likely been explained (several times??) but I can't figure what or how to search to find the answer.

I have 3 files -- Students, Clubs, ActiveYears. In Students, I have a constant::constant relationship with clubs which gives me a list of all clubs. Now I want to select a club from the list and have 1) the club details (address, etc) show (from Clubs) and 2) the club roster (I have a relationship between Students and Clubs (matchForClubName where _gMatchClubName (global text field in Students) is related to MatchClubName (text field in Club).

then I want to select a name from the club roster and have the student details show (from ContactInformation and ActiveYears (which has records for each student each year they participate).

I'm sure I haven't explained this very well, but hopefully someone out there can figure out enough to point me in the right direction.

TIA

Abbe 8-)

[SassyTexan]

look up conditional value lists