This problem has been niggling away at me for a while now.
I have created an extensive database that holds all the data for my companies product base.
There are 4 tables that all tie in to 1 form. Each record is one product.
I currently have 2480 products, therefore 2480 records.
My issue is that I have no decent way of navigating through the records.
Im running Access 2007.
All the data is there for it i just dont know how to utilise it.
Here is an example row of the main product table.
Product Type | Product Section | Product Sub-Section | Item Name
Its a perfect product tree. Section > Sub-section>sub-sub-section.
What i want is to be able to have three drop down boxes so when i pick a product type in the first one, only the sub sections of under that are available to click in the 2nd one, then when i pick a sub section, only the sub-sub sections are available in the 3rd one.
Then once the criteria is selected, it will show me (somehow, a report or in a datasheet) the records that apply to those filters.
Ive been trying to find a solution but this seems to incorporate a lot of aspects of access of which i have limited knowledge.
i wondered if anyone knows of any way of doing this?
Just some guidance or even some code i can manipulate to meet my ends.
I would appreciate any help.
Thanks