Hello everyone,
I have three Dataverse for teams tables
Team: ID, Name, Type,
Player: ID, Name, Position
TeamAssignment: ID, PlayerID lookup), TeamID (lookup)
I want two combo boxes,
comboBox1: items=Teams
I need comboBox2 to filter only the Name of the players for Team selected in comboBox1
I did not build the tables and do now want to alter them whatsoever (ie: add a TeamsID column) since they are quite large and important.