I have the following tables.
Model, Main Category, Sub Category1, Sub Category2, Parts List, ControlNumber.
I have a general search which I can choose by selecting Model, then the various categories and this is fine. However, the other type of search is when someone enters a Control Number.
This number is made up of sections which will break down to the correct Parts List.
xxx - Main Category
yyy - Sub Category1
zzz- Sub Category2
B1 - Parts List form
The idea is that when a user enters the Control Number, they get directed the Parts List pertaining to to only that Model with its connected categories and subcategories.
Any ideas how to start?