Appreciate the example. I did alot of the GM cars today. Specifically Camaro, Corvette, Cobalt, Aveo, Impala, Lumina, Malibu, and MonteCarlo.
Just for better understanding, will this work kind of like a step process similar to below:
1) read the World Identifier to determine the Manufacturer
2) read the year
3) read the make based on the Manufacturer
3) read the model based on the make
4) read the body style/edition based on the make
5) read whatever else - restraint, engine, etc.
If that is the case, cant we just define the model based on just the first 2 digits in the model sequence, and let the app look at the next digit to compare it to a body style table, and then report the correct body style for the model. This would mean adding a body style table to the database, but would resolve the issue of looking up the weight and such for trucks, as well as difference in camaro coupes and convertibles.
I realize that different manufacturers define models with different
series of digits, so I assume this would require different "look-up" processes and possibly different tables depending on the manufacturer, but this might assure the same level of detail reported for each manufacturer.
Bookmarks