add/remove from drop down lists

G

G Stoner

I have 2 drop down lists working off of the same table. I want to be able
to click on an assign button and assign an area from the UnAssigned Area
drop down list to a crew by inserting that crew's ID into the table for that
particular area.

I then want to go to the crew's assigned area drop list to and see those
areas assigned to that particular crew - inside that drop down list I have a
delete button next to each assigned area - I want to be able toclick on that
delete button and remove the crew's ID from the table for that particular
area, making it available in the un-assigned area drop down list again so it
can be re-assigned to another crew.
 
Top