dynamically update Enum

[DEVBK]

hello Hive mind, need help with a community tennis doubles app I am working on:

1.  4 Players are selected via enum dropdown players[players]

2. Once the first player is selected, I would like the enum dropdown to now show the name of the 1st player and  so on; Player 3 drop down  to not show the names of Players 1 and 2.

Data validity tab has players[players].  I have tried adding winner 1<> winner 2  in the data validity tab as line 2 But does not seem to work.

Screenshots of the form and the expression attached.

Your help is much appreciated.

[Steve · Accepted solution]

For Player 1: (players[players] - LIST([Player 2], [Player 3], [Player 4]))

For Player 2: (players[players] - LIST([Player 1], [Player 3], [Player 4]))

For Player 3: (players[players] - LIST([Player 1], [Player 2], [Player 4]))

For Player 4: (players[players] - LIST([Player 1], [Player 2], [Player 3]))

[DEVBK]

Many thanks for your help Steve. Worked like magic !