Select Multiple Options In Form

[uneek78]

I have a form where I would like the user to be able to choose multiple checkboxes, buttons, or whatever that would go in the same field in a table. Basically I have several locations. I would like the user to be able to choose several locations at once and once they save the document the locations chosen save into 1 field in the table related. Is this possible?

 

[boblarson]

It is possible Is it wise - No. Is it a proper way to store data in a database? No.

You should not store multiple data within the same field. If you have multiple data, you should have another table to store the multiple values for that record and then you would normally use a form/subform setup. That is the proper, normalized way to set it up.

 

[Demetious]

Bob,
Can you give an example when using multiple fields in a DB is ok? I am using one because I'm not sure how else to do it. I'm unclear about the use of a subform but I will check it out, thanks.