I have tables A, B, and C each having the field PartNumber.
tables B and C also have the field DieSize.
I have a report that will use this query to display the record results on a label.
In English, this is the query:
Find the match in TableA.PartNumber and (TableB.PartNumber or TableC.PartNumber)
Return the DieSize.
There should be only one match.
Display PartNumber and DieSize on the report.