How can I use a multiple selection list box to store multiple ans.

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

Guest

I am trying to set a field that will accept multiple selections from a list
box. Please Help!!!!

Urgent!!!!
 
This is not the normal method of storing multiple values. The accepted
method is to use a subform that is bound to a related table like the Orders
and OrderDetails in the Northwind database.

Can you get around not using a list box?
 
I am trying to set a field that will accept multiple selections from a list
box. Please Help!!!!

Urgent!!!!
Click to expand...

In a relational database, one does NOT store multiple values in a
field. Instead, you should use two tables in a one-to-many
relationship; and store the multiple values in the "many" side table.
A Subform is the simplest way to do this. If you really need to do it
using a listbox, I've got some sample code which will move selections
from a Listbox into a many-side related table.

John W. Vinson[MVP]
 
Hi Marie.

As Duane and John have explained, using a list box to stuff lots of
different items into one field is a really bad design - even in Australia.
:-)

One of the most basic rules of relational data is that each field must be
atomic, i.e. it must contain only one thing. To read further about this,
search for "normalization".

Micorosoft's basic introduction is here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209534

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
HI I found this post in my search and I am interested in the sample code
which will move selections from a Listbox into a many-side related table. I
DO have two tables in a one-to-many relationship; and store the multiple
values in the "many" side table.

I realize asking for this is bad form but I want to compare my options.

Thanks bunches!!
Shel
 
Back
Top