M
Maree_in_Australia
I am trying to set a field that will accept multiple selections from a list
box. Please Help!!!!
Urgent!!!!
box. Please Help!!!!
Urgent!!!!
How can I use a multiple selection list box to store multiple ans.
D
Duane Hookom
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?
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?
J
John Vinson
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]
A
Allen Browne
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]...
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]...
S
Shel
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
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
D
Duane Hookom
You might want to search Roger Carlson's small sample databases at
http://www.rogersaccesslibrary.com/TableOfContents3.asp. Search for this
file or possibly others ListboxSubform.mdb ( intermediate )
http://www.rogersaccesslibrary.com/TableOfContents3.asp. Search for this
file or possibly others ListboxSubform.mdb ( intermediate )