Referencing multiple records in one base

[Isaac_S]

I know there are a million variations on this question already but I’ve read all the solutions and spent several days trying to resolve it and am still stuck. Perhaps my issue is unique, perhaps I’m just slow.

I have 3 tables in my base. Trip Test, Members and Trip sign ups.
Members is a list of members

Trip Test is a list of trips

Trip sign ups is a sign up form where a member selects which member they are in a form (from a look up of the Members list)

Which ends up looking like this in grid view

I am trying to create a view in Trip Test that pulls in and shows which member has signed up for each trip (preferably so that member can also be clicked on to show additional info like their photo). All I’ve ended up with though is another selection field to choose those members rather than pulling those that have already signed up.

The hoped for behavious is that field 5 in the Trip Test gallery/table displays information that’s in the 2nd column of Trip Signup.

I’ve been tearing my hair out. Any help is greatly appreciated. Thanks in advance!

[TheTimeSavingCo · Accepted solution]

Hey, I’ve put something together here for you, but I’m not sure if it’s what you’re looking for

Members table:

Sign ups table

Trips table:

Trips table, gallery view:

Trips table, gallery view, Trip 1 clicked:

Trips table, gallery view, Trip 1 clicked, then Member 1 clicked:

[Isaac_S]

Thanks so much for this Adam, very grateful indeed. I’ve started playing around with it and trying to get my head around how to make it work with my existing data. I’ll follow up once I’ve had more time.

[Isaac_S]

Well, it took 8 days to get my head around it but I’ve done it! Hugely grateful Adam. Thanks!