I have a problem entering data into database.
I've got 3 dropdown boxes with multiple select feature. So users can choose more than one item in each dropdown. How can I get all of the selected items from all dropdowns into a database ? Please, pay attention that due to needs for some mathematical operations the datatypes of the fields where passed parameters will get in must be the INTEGER type.
My application is on ASP platform and the database is MS Access.
I have got just one table with some fields like UserID, Date, Drop1, Drop2, Drop3 and etc.
I want to have all selections made by specific user. Records owners can be recognized by UserID. So I would be able to sort data by UserID or make some calculations on the fields like DROP1 or DROP2 or DROP3.
for instance, number of selected items IDs are different:
DROP1 - 1, 4, 7, 8, 9
DROP2 - 14, 24, 31
DROP3 - 8, 9, 11, 23