Welcome Guest, Not a member yet? Register   Sign In
Multiple Dropdowns - Unique Values?
#1

[eluser]chandlerou[/eluser]
I have a form that a user will be filling out. They will be assigning users to positions i.e. (Matt is frontend, John is backend, Eric is Database, etc...). My initial GUI for this (Since the positions are static and the users dynamic, was to have just a dropdown list of users for each position.

Therein lies the issue.

How can I accomplish this, if only one user can work only one position?

I have the job ID and user ID as a compound key ensuring only one user can work one position per job, so when something like the image is inserted into the database, only the first inserted instance is there.




Theme © iAndrew 2016 - Forum software by © MyBB