Server Validation Question
I'm after some guidance on how i can achieve following.
My logged in users are able to select tags from a drop down and im using INSERT to add their selection to a table.
The user ID is added along with the selected items ID
I want to prevent the user from selecting the same item 2 or more times from the drop down and adding it to their tag list.
I tried using validation on the selected item against a recordset that looked at the values already selected by the user, but that failed!
suggestions welcome.