Getting value from a table based on one of the possible foreign keys
You're ganging the tables together in a very awkward manner. Say you have a table of all car types, a table of all car models, a table of all car versions, a table of all car parts and finally a table with problems (dent, etc). Then you can have one intersection table that relates all of these together with the price to fix the problem. Using simplified data, a row of this table might look like this:

S, TC, Z, FDP, D, $250


This row shows that the price to repair a dent in the front door panel of a Toyota Camry sedan, ZXI is $250.