How to create multiple combo boxes for a single field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i would like to know if it is possible to create multiple combo boxes for a
single field? in other words, is it possible to have an identical combo box
appear each time you select a choice from a previos box to give you the
possibility of selecting multiple values for a single field. ex. if you have
a fieldname entitled "dislikes" and you choose dogs from the dropdown menu,
another dropdown menu will appear that allows you to choose a second dislike
if you have one.

thank you
 
mochan28 said:
i would like to know if it is possible to create multiple combo boxes
for a single field? in other words, is it possible to have an
identical combo box appear each time you select a choice from a
previos box to give you the possibility of selecting multiple values
for a single field. ex. if you have a fieldname entitled "dislikes"
and you choose dogs from the dropdown menu, another dropdown menu
will appear that allows you to choose a second dislike if you have
one.

thank you
Click to expand...

You have a one-to-many relationship. One parent entity with zero, one, or
many dislikes. That calls for two tables and the use of a subform to enter
the related records. It is never proper to store multiple values in a
single field.
 
Back
Top