I’m new and would greatly appreciate some help.
SETUP
I have a collection titled Members . In that collection, I have a column titled ownerId and another titled team . The team column field type is set to reference another collection called Teams (column is title ).
I have another collection titled Traveler_Names . In that collection, I have a column titled teamAssociation . The teamAssociation column type is set to reference another collection called Teams (column is title ).
WHAT I NEED
I would like to filter the Members collection by ownerId and the currently logged in user ID.
Then, I want to to take that result and use the team column to filter the collection Traveler_Names . After that filter is done, I plan to connect it to a repeater.
WHERE I AM AT NOW
I have a page with two datasets - Members and Traveler_Names. I have code working that allows me to do the first filter on the Members dataset. I had thought I would be able to use the dataset settings on Traveler_Names to create a filter to connect teamAssociation on the Traveler_Names dataset to team on the Members dataset, but when I go to select the Members dataset, it is greyed out. And my attempts to do it in code have been unsuccessful.