Combo box

  • Thread starter Thread starter Sara
  • Start date Start date
S

Sara

Hi,
I have a combo box on a form that uses a table for the
list. After you choose one from the combo box, I want it
to let you add another choice from the combo box and put
it in the same field.Is there any way to put a comma or
simi-colon after the first one then put the second? Right
now it will just overwrite the first one chosen.
Thanks!
Sara
 
Hi,
I have a combo box on a form that uses a table for the
list. After you choose one from the combo box, I want it
to let you add another choice from the combo box and put
it in the same field.Is there any way to put a comma or
simi-colon after the first one then put the second? Right
now it will just overwrite the first one chosen.
Thanks!
Sara
Click to expand...

Stop.

What you're trying to do violates the very first principle of
relational database design: fields should be 'atomic', i.e. they
should have one and only one value.

If you want to have a one to many relationship between the entity
modeled by your main table, and this keyword, *you need another
table*. Use a Subform based on the table, with the combo box on the
subform, and add *one record* per keyword, rather than trying to jam
multiple keywords into a field.
 
Back
Top