Hi Folks,

I have a page made up of 5 text boxes which requests zip codes from my members. The members have the option of entering between 1 and 5 zip codes which is used as a search value on another page.

My problem is how do I get these multiple values into the database without having to create 5 seperate pages.

Here is my zip code database table design which records each zip code entered seperately, associates it to the member and auto numbers the entry.

Entry ID - primary key
Member ID - foreign key to members detail table
Zip Codes - column to hold zip code values inputed by members

I will also need to build a update page for these 5 zip codes in case the member decides to add change or remove zip codes associated to them so they must be retrievable by searching on the member ID number.

I am using SQL 2000, ASP, VbScript

Any help would be greatly aprreciated.

Thanks,

Rob