Jump to content

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


Lougee
 Share

This topic is 6559 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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-)

Link to comment
Share on other sites

This topic is 6559 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.