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.

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)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"tty" <(E-Mail Removed)> wrote in message
news:C20B79AB-1AB8-4E6F-8ACB-(E-Mail Removed)...
> 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.
>
>
>

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

"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "tty" <(E-Mail Removed)> wrote in message
> news:C20B79AB-1AB8-4E6F-8ACB-(E-Mail Removed)...
>> 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.
>>
>>
>>
>
>