Searching for records based off two fields from two separate tables at once

[Madmax2]

Okay so i messed up the design of my database and need a small search query as a work around.



right now i have toolkits in a table primary key is uid. But in many cases it is the catapillar part number for this kit

i have individual items of the kit in a separate table which also have cat part numbers attached to them

lastly (for gee wiz). My third table provides the items per kit ids

mainly not sure how to setup the query i need. I want it to search for a part number in table1 field uid and a part number in table2 field part#

any thoughts?

edited: Basically you put in the part number and it brings up all posible instances in both tables

[June7]

How are tables related? What is common field that can be used to join them in query? Post example of table structures.

Then apply same filter parameter to both fields with OR operator.