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.