How do you do this???

[Irishmaninusa]

Hi Everyone,


I have access form (using Access2000) and on this form I have two
listboxes.....where I allow the user to have multiple selects. And the two
controls are linked to fields in my contact table. My question is how I get
the contents selected by the user to be stored in the table using just the
buttons where you can move through the records in the database table. I am
hoping that this can be done automatically without having to write lots of
code to do so. Hope to hear from some one soon.

--
J.Daly
structure:interactive
Ph: 616-364-7423
Fx: 616-364-6941
http://www.structureinteractive.com

 

[Rick Brandt]

"Irishmaninusa"

Hi Everyone,


I have access form (using Access2000) and on this form I have two
listboxes.....where I allow the user to have multiple selects. And the two
controls are linked to fields in my contact table. My question is how I get
the contents selected by the user to be stored in the table using just the
buttons where you can move through the records in the database table. I am
hoping that this can be done automatically without having to write lots of
code to do so. Hope to hear from some one soon.

Multi-Select ListBoxes never have a value. Their use is not intended to
allow multiple values to be stored in a single field as that violates
proper database design. If you need multiple values assigned "to a field
in a row of a table" then you need an additional table with a 1-to-many
relationship set up between the current table and the new one. Then you
can have as many "related" entries in the new table as you need and still
only have one value per field.

 

[Irishmaninusa]

thanks.....my next question is how do you do that.....could you send me a
sample database on how this would be done



email is jdaly at structureinteractive dot com

 

[Sandra Daigle]

Take a look at one of the SelectRecords sample dbs on
http://www.daiglenet.com/msaccess.htm for some ideas.