Hi There

I have an access database that has two tables inside one that has all products and one that has all categories,

On one of my pages i have a drop down list that uses a recordset two display all the categories, then once clicked it returns a results page with the product info.

The results page has 4 colums showing the required info but on some of the categories i need it to show different columns to some categories.

I think basically what i am asking os it possible to have a couple of tables on the reults page but the secound table would only show if the required column for that product is populated could you use a show if behaviour??

if so how could you do it and if not is what i want to do possible

Thanks

John

Not sure i follow exactly what your trying to do but I do know your best creating complicated queries in access.

I have a site which uses multiple tables, for products, categories, sub-categories, etc. To access the info I want on a particular page I have a pre-made query in access.

Read up on access and related tables, you'll find it helps...

DWMX | ASP | ACCESS

I know ounded a bit confusing but basically all i want to do is i have a page that has a list populated by a recordset how could i have so lets say i had two entries in the list if selection one was chosen the page would jump to products1.html and if selection two was chosen it would jump to products2.html, i believe this would be in the submit code some where..

Any idears

John



Edited by - pepperjap on 22 Jan 2007 12:46:30