Multi-select no data in table

[Subzero]

Hi All,

I really hope that someone can help me.

I have quite a big database and I have lists boxes on every form. Most need
to be multi-select, which they are however what ever I select either doesn't
transfer at ALL into the table or only one value does. Please could someone
tell me a way to fix this?

Sub x

 

[scubadiver]

Unfortunately, a cell in a table can't contain multiple values. I don't know
what other answers there are to having a one-to-many relationship.

 

[Jeff Boyce]

You've describe "how" you are trying to do something, but not "what" or
"why". What business need are you hoping to solve by having multiple values
(those selected in a listbox on your form) go into a single field in a
table?

By the way, one of the basic design principles of database design is "one
fact, one field". By trying to stuff multiple selections into a single
field, your design violates this principle.

If, as your description implies, you have many one-to-many relationships,
you need to reconsider your basic table design. If the terms
"normalization" and "relational design" don't mean much, plan to spend time
learning more about them before returning to making Access do what you want.
After all, Access' features and functions expectation relational data.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/