How to create multiple combo boxes for a single field?

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
 
R

Rick Brandt

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top