I have a table of users and a table of trades, for example:
- User 1
- User 2
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!