Using Checkboxes to insert data

Report · Apr 25, 2006

Ok Helpful peeps, please help....

Two questions. Can you use multiple checkboxes and write the values to one field of a database? If so how?

I need to do the following. I am doing an second hand car site. The car dealers maintain and upload there own vehicles. I have a field in the database for description. To save the dealers time I want them to be able to select key data (ABS, Electric Windows, etc) via checkboxes and then write the more unique features (colour, milage etc). When the dealer submits the form all the data is combined into one field (with spaces) called description.

So is this possible? (I hope so otherwise I need to add lots of fields to the database and rework many many pages. Clients don't you just love them!!!!)

I'm using DW8, ASP VB all hooked up to an ACCESS database

Please help. I am soooo close to launching this site......

Best Regards

Stuart

Report · Apr 25, 2006

Yes, I did something a lot like this - a long time ago. On the form where the dealer fills in the car info, there was a textarea called "fmFeatures" and a button called "Select Features" that opened the attached pop-up window that did what you're asking for. The various references to "ions" used to read "Options". Don't know why or how the options became ions...

Good luck

Doug

------------------------------------