Hello and welcome @John_Hyland!
To make sure I fully understand your situation- it sounds like you have several tables located in one base? If that is that situation, it sounds like using the linked record field would be the key. You could link certain parts to certain makes and models and then easily create filters whenever you’d need to see which parts work for the matching make and model.
For extra context, if you did need to pull information from one base to another base you can use Airtable Sync.
Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .