• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.