Database form field

[Guest]

my database running under access 2000+ft 2003+iis5. About 2,000 records.
database is been created with frontpage database wizerd. Database work fine.
There is no problem with it. my submission form have 7 different dropdown
fields. When the user click on the drop down fields and select the
appropriate prduct, the products automatically goes to database. Suppose now
the user want s to select multiple items on each drop down field, how i can
enable that function on the database. I tried enabling the allow mutiple
selection in the form and it works and database record updated. If I look up
the database, all those mutiple selection stacked up in the signle column.


Suupose i have drop down field menu name

test (allow multiple selection is enabed)
- est1
- test 2
- test 3
- test 4.
- test 5

if i select test2, test4, test 5 and hit on the submit button. All these
field will be updated in the database but not as seperate record but like this

test,test,test (sigle record) not three different records.
How can i endable them to be updated as three different record in the
database not as one field.

 

[Thomas A. Rowe]

Correct, as the dropdown field has a single field name, so all content will be written to that field
name in the database, separated by comma.

You will need to learn to hand code ASP/VBScript to split the values into separate fields and then
use those field as needed.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Tom Gahagan]

AND..........(this comment is for tty)

It sets up the need for additional tables if you are going to have a
normalized database.

Best to you.....
Tom Gahagan