Populate fields from a dropdowm menu/list

Dear Jason/Ray, I have two tables - one contains the name of teams (U-10, U-12, U-14,etc) and the other table contains the players.

Each managers sets-up their team, by registering their team - say U-12 team. The Team table contains: ID, username, password, Team Name, Captain Name, Captain email, Captain phone.

After he registers, he is brought to a login page and after logging in, he will see his team name and a list of players from the players table (the only players in the table after registering, will be the captain - the captain is also added to the players table as well as the Team table at registration). The manager can now add into the players table the additional players on his team.

QUESTION
I want to give the manager the option to change the captain of his team if he wishes. The idea would be to go to an 'edit team page' and have a dropdown menu from which he could choose the new captain from. The dropdown would pull its information from the players table, but it would be limited by a recordset that only shows players related to a particular team, say U-12's.

I hope you understand what I'm trying to do. Can DataBridge help me here?

Create a recordset to return the captains name and ID

you will have another recordset on the update page that returns the data to be updated

add a select list to the page and populate it from the recordset. Set the value to the ID column and the label to the name column.

in the Select Value equal to section of the dynamic select list settings, click the lightning bolt icon and select the captain ID column from the main recordset.

in the update record behavior, bind the captain column to the select list