AnsweredAssumed Answered

Unique Dropdown Selection

Question asked by guit4eva on Jul 13, 2017
Latest reply on Jul 14, 2017 by guit4eva

Hey guys,

 

I have a table of users and a table of trades, for example:

 

[Users]

- User 1

- User 2

 

[Trades]

- IT

- Chef
- Mechanic

 

What I would like to do is have a dropdown of Trades on the User layouts - which I have now by creating a relationship based on a foreign key in Trades table - however, it requires the following:

 

1) The trade can only be selected once (to avoid duplicate entries)

2) Once selected, it must be removed from the dropdown

 

Can anyone point me in the right direction to achieve this? Will be much appreciated!

 

Thanks in advance!

Outcomes