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
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