Chose Multiple Values in Drop Down

  • Thread starter Thread starter stnkyferit
  • Start date Start date
S

stnkyferit

Hi!

I am sure there is a quick answer (I hope), but I am boggling my min
trying to figure it out. I have a form with a drop down box tha
pulls values from a table (tblInfraction). The selection from tha
table updates to another table (tblMain). At first this would be fin
because I can query the results of that field, i.e the number o
specific infractions, but I am now realizing that people may need t
chose more than one value from the drop down. My questions are

Is it possible for users to do a CTRL + Click on the drop down value
for more than one selectio

Do I now have to add a Yes/No value which contains the valu
information of tblInfraction to tblMain in order for a CTRL + Clic
to work

I am sorry if this doesnt make sense, but hopefully someone can hel
:-
 
On Mon, 26 Sep 2005 15:46:07 -0500,
Hi!

I am sure there is a quick answer (I hope), but I am boggling my mind
trying to figure it out. I have a form with a drop down box that
pulls values from a table (tblInfraction). The selection from that
table updates to another table (tblMain). At first this would be fine
because I can query the results of that field, i.e the number of
specific infractions, but I am now realizing that people may need to
chose more than one value from the drop down. My questions are:

Is it possible for users to do a CTRL + Click on the drop down values
for more than one selection

Do I now have to add a Yes/No value which contains the value
information of tblInfraction to tblMain in order for a CTRL + Click
to work?

I am sorry if this doesnt make sense, but hopefully someone can help
:-)
Click to expand...

I think your table design may be the problem.

If you have a Many (people) to Many (infarctions) relationship you
need THREE tables:

People (your tblMain I presume)

Infarctions (tblInfarction)

Charges (or some other appropriate name)

This final table would have a foreign key to tblMain and another
foreign key to tblInfarction. If you "throw the book" at someone, and
need to list twelve infactions, there would be twelve records added to
this table. A continuous Subform based on Charges would be the simple
way to enter this information.

John W. Vinson[MVP]
 
stnkyferit said:
Hi!

I am sure there is a quick answer (I hope), but I am boggling my mind
trying to figure it out. I have a form with a drop down box that
pulls values from a table (tblInfraction). The selection from that
table updates to another table (tblMain). At first this would be fine
because I can query the results of that field, i.e the number of
specific infractions, but I am now realizing that people may need to
chose more than one value from the drop down. My questions are:

Is it possible for users to do a CTRL + Click on the drop down values
for more than one selection

Do I now have to add a Yes/No value which contains the value
information of tblInfraction to tblMain in order for a CTRL + Click
to work?

I am sorry if this doesnt make sense, but hopefully someone can help
:-)
Click to expand...

A "drop down", or combo box, can only hold one value at a time. In any
circumstance where you think you need to somehow choose multiple values
from the combo box for a single field, what you've really got is an
implicit one-to-many relationship, where each of the values you would
choose in the combo box should be stored in a separate record, in a
table that is related to the original one.

So if you have a table tblMain for which multiple infractions may be
recorded for a single record, then you need a table, maybe
tblMainInfractions, in which each of these related infractions will be
stored. You would commonly present these related infraction records on
a subform.
 
Back
Top