
Hello all,
There are various threads regarding cascading dropdowns but I cannot find the answer so far, so here we go.
I have two custom tables in dataverse: Clubs and Players.
The Players table has a lookup column, which points to Clubs (one club has many players).
Now, on a form I would like two dropdowns; lets call them dropClubs and dropPlayers
I have populated dropClubs by simply pointing to the Clubs table in its properties.
The problem is how do I now make dropPlayers filter based on the selected item in dropClubs. Whatever I try from various videos etc, seems to be invalid. I have also looked at the depends on, but got nowhere.
I have got it working as a test using collections, where I just create the collections via test buttons on screen. For example in the items of dropPlayers, I have used Filter(colPlayers, Club = Dropdown1.Selected.ChoiceID). However, the data should come from these dataverse tables.
I must be missing something fundamental. Should I be using collections populated from the dataverse tables? Something else?
Thanks in advance.