I have these database tables Vehicles, Accessories, AccLinking Vehicles has fields id, vehicle, name, description, status, who, thedate, comments Accessories has fields id, accessory, name, description, status, who, thedate, comments AccLinking has id, vehicleid, accessoryid where [login to view URL] represents an id in Vehicles table and [login to view URL] is an id in accessories table I want to have a page whereby I link accessories to a vehicle. The page should be presented like this. Name of the vehicle at the top Then two multiple select lists side by side big enough to show about 20 accessories in each. In the middle I want two buttons with text Link--> and <--UnLink The left side should contain all the accessories not linked and the right side should contain all the accessories linked already. I want to be able to select one (or multiple if possible) from either select list and press a Link--> or an <--Unlink button and see that the <options> are moved from side to side. Then at the bottom I want and Update button going to another .asp page called [login to view URL] which will add any new links and delete any links no longer existing. Maybe it is easier to delete all links existing and then add the links again. Anyway.. I need the sql to do this and then redirect to the same page again.
## Deliverables
1) 2 .asp pages, one called [login to view URL] and the other [login to view URL]
2) ownership of the code
## Platform
ASP
html
javascript
Windows 95,98,Me,2000,XP
Internet explorer 5.5+ only required