I have an access database which has a table of categories and
a table of products, when the user clicks on the relevent category
the products relating to that are listed.
is there a way so when the user clicks on a certain category
the results page could be a set of tables pulling the relevant
information, at the moment the results page is one table, which i
would still need to keep for the results of the other categories,
it is only one categorie that would need to display more than one
table.
How could i do this
John