I’m a bit of a newbie when it comes to using a database with a webpage. It is important that I use MSAccess for this.
I’m trying to create a business directory that will show results depending on what is chosen in the category list.
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?
