Update Table from Drop-Down Menu
I have an MS Access Database. Inside this database I have a table which holds these fields:
Category - Business - Address - Phone - Fax
On my webpage I have a drop-down menu that will hold a list of each one of the Category items in it.
When I select an item from the Category list I want my table to give me all the businesses in that selected category.
(just as a side note, my table is created as a "Repeated - Server Behaviour" item with the items of database.business - database.address - database.phone - database.fax)
Problem is, how do I do this? Everywhere I look I keep finding ways to "auto-populate" my drop-down list. But that's not what i want to do.
What I want is to populate my table according what the drop-down list item that is chosen. Can you help point me out how to do it?
Thanks,
Josh
Comments
auto-populate dropdown is the answer
But you do want to auto-populate the dropdown, auto-populate with the labels/values of your Categories. As for using the same page with different data, the SQL Query will use the Category as the WHERE clause, and you can assign the value of the WHERE Category to come from the dropdown, all in the 'Advanced' SQL dialog.
Hi I think this is what you want
I am a bit sure that what you want is something like
http://cc.1asphost.com/fahdi/business/
Ok, if this is something you need, I can be of help.I can give this code to you.
Regards,
Fahd Murtaza
You must me logged in to write a comment.