values of comboboxes and multiple choices 1

[Machiaveli]

Hi,

I was wondering what the best way is to store the values of comboboxes and listboxes.

Until now i always use an integer value which i store in a field. This works for a single choice option, but how about when i have a field where there are more than 1 choice available in a combobox or listbox.

How should i store that in a field if you taken account how it should look on a form.

 

[bitmite]

unfortunetly with relational databases this is not advised my suggestion to you is if the user can select more then one value then make a table that hold those selected valus along with the ID number from the parent record and use a subform and have the sub form in datasheet view.

this in the database wold is call multivalue dependency if you want look it up on the web. most people make the mistake you are tring to make and it messes up down the road.

Brought to you By Nedaineum
|
|
The port to Geektron

 

[Machiaveli]

Hi,

Thnx for the advise. I've looked up about multi-value dependency, but i didn't find any examples which i could reference to.

Can you help me with a example how to use multiple values?

I know i have to create another table based on your advice, but how should the data-entry be if i set up a field which is in datasheet view? I don't get that part.

Thnx

 

[PHV]

I think you have to build a one to many relation

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244