I'm working on a database and hope someone could help me with a direction to head. I don't have all of the details worked out yet but the database is exactly like an autoparts selection database. I'm using VB
.NET and SQL.
Here's what I want to do:
Make: Model: Engine: Part:
Looking at my example there are selections based on a previous answer and if you were to select Ford for example you wouldn't see Camaro, etc but you would get the Ford cars. I need to ultimately drill to a SKU type number for the last items in the "Trail". Every car has a headlight but Mustang headlights are different from Corvette.
Does anyone have a clue to this? I'm looking for how to structure the tables. I think I can figure out the VB
selection tree once I get the tables setup. I also want to maintain 3rd normal as much as possible. I know it has to be a common thing.