Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

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

February 7, 200421 yr

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