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!