How to get listbox control to work????

Question

Can someone answer a question for me? I have a listbox control that gets values for both text and data from an employee table. The problem I am having is how to handle the data returned for the datavaluefield. The scenario: A user selects from a list of employees those employees who use widgets. When the form is submitted however; those values need to be entered individually for each user into a seperate table called emp_widgets. That way the records are entered into the emp_widgets tables like: Emp_Widgets id emp_id WidgetID 1 1 2 2 2 2 3 3 2 Question: Is this the practical way to handle data from a multi-select listbox control? If not can you tell how to handle this scenario? If so can you tell me how to accomplish this scenario? Thank you very much for your time. Sincerely, Tim

Adam Erstelle · Answer

Hey first your table should not have an ID column. It should have only Emp_id and WidgetID. For accepting user input you should have a listbox containing the employees. Then you could have checkboxes (or a seperate listbox allowing multiple selections) with the available widgets. When the user selects an employee your program could retrieve what widgets are in use by the selected employee and display the results accordingly in the checkboxes or listbox. After the user makes their changes you will have to capture them and update the database table as it happens.