Entering multiple selections from a menu list all at once

R

Raoul Pop

I'm using an Access database for a website. I need to be able to display a
dependent menu list
(father-son relationship) on a web page. I'd like the user to be able to
make multiple selections in each of the menu lists, and to be able to enter
all of those selections into a database all at once through an insert
command. Here's an example:

Fruit apple
orange
pear
Vegetable carrot
celery
cabbage

I'd like them to be able to select from both categories, say Fruit and
Vegetable, and Apple and Carrot. Then, when they'd click on the Submit
button, their selections would be entered into the database at once. Let me
further clarify. I don't need to know how to create the dependent menus. I
think I've got that covered - though I'm very open to suggestions if the
answer to my solution
affects the way the menus need to be built. What I need to know is how to
enter all of the
selections into the database at once.

Can you point me in the right direction? Is there a tutorial somewhere that
would
show me how to do this? Do I need to write a stored procedure, and if so,
where
do I begin?

Thanks!!!
Raoul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top