I have 3 collections: Members, Tournaments, TxResults
TxResults contains a reference field named Tournament mapped to the TxID field that is in the Tournaments collection as well as a reference field called Member for the field Member Name in Members.
I have added a table to the page connected to the TxResults dataset, then created a dropdown connected to the Tournaments dataset to display a field called Location. Location is NOT a reference field in TxResults, but the TxID is.
What I would like to have happen is when the Location is selected (because it is more human-readable than the TxID) from the dropdown, the table is filtered to display TxResults for only that TxID.
Right now, the options in the dropdown is populating correctly, but when I select a Location, the table refreshes and there are no results.
This is what I have in my dropdown event:
Does anyone know if what I would like to do is possible?
I have tried following all of the Wix tutorials on YouTube regarding datasets and I also followed the one from Code Queen with using multiple dropdowns but that is not quite what I need.