View Full Version : Table not populating


wannabepro
01-26-2005, 09:03 AM
I created a form and in form I have created a combo box, and I can make as many selection I want through multiple box properties; however, its not populating in the table. Now if I keep select non in multiple menu I can input the value in table through that form. How can I make this field populated with more than one value.

Need help urgently. Thanks in advance :)

Pat Hartman
01-26-2005, 11:54 AM
You created a listbox. Comboboxes do not have a multi-select property. First normal form says that all fields should be atomic. That means "not further divisible". That means that storing multiple values in a single field is not supported by the db engine. This doesn't mean that you can't do it. It just means that Access will not support it. You have a 1-many relationship. The many-side data should be stored in a separate table. Do some reading on normalization.