Comma Seprated values from Form to DB

Progress2007

New member
Local time
Today, 15:47
Joined
Jul 17, 2009
Messages
2
Hello i have a access form on which there are multiple check boxes. all values that are checked will go in to the single field of DB.means if user selects 3 check boxes the the rexpective values like 1,2,3 will stored in that DB field and next tiem when user selects that record all check boxes should checked accoedingly..

Please tell me how can i do this..
 
Storing multiple values in the same field is usually not advised as it usually identifies a problem with the design of your database. You would probably need to create a table with the values that each one of your checkboxes represents. Get rid of the checkboxes, and create a table that links the table that your main form is based on, together with the values from the newly created table. This is referred to as a junction table. If you need a clearer explanation, first search the forum for 'normalization' and then post back if you have questions or would like to see an example.
 
Are we talking about option groups or tick boxes? Each item in an option group has an index value that can be stored in the table. For multi select tick boxes you can either store each response in a seperate field or use a decision tree to evaluate the true false responses.

David
 
Yes, storing the value of each checkbox in it's own field would be appropriate. The way I interpreted it was Progress wants to concatenate the value of multiple checkboxes and store that in a single field, which is usually not appropriate.

Another way to explain what I said in post #2. Instead of checkboxes, have a combobox with all the possible values or text strings. Next to it, have an 'Add' button that adds the selected value into a subform. I already have a viable example, so here you go.
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom