That's not producing the results I need for the third menu, which is MODEL. I think there might be confusion. I referred to 'make' in my last post because you asked about basevehicleID and what the relational key was. I was just answering your question.
I need 3 menus.
The first two I have. I'm trying to get a statement to work that will show a list of available MODELs from the user's first two menu selections (year, make).
There are 4 tables required to do this (I think). As mentioned above, they are Year, Make, Model, and BaseVehicleID. The last one contains all the relational keys for the other three. Here are the table contents once again to save you some scrolling:
wich contains one column, YearID. The YearID is actually the year (ie, 1996, 1999, etc.)
BaseVehicle. The columns in it are:
Table three is Make. It contains:
Lastly, Model which contains: