Sharing a common fields

  • Thread starter Thread starter Lana
  • Start date Start date
L

Lana

I have a table that shares the same field with 2 different fields from
another table. Example... the 1st table is bearings the 2nd table is parts.
The field in the bearing table called dimensions I want to join to 2 fields
in the parts table called inner journal and outer journal. Can I do that and
how do I go about it? I have played with the joins and come to conclusion
that I need 2 spearate queries and then join them that way. I wanted to check
to see if that was what I need to do.

Thank you.
 
Your problem is in having the parts table fields called inner journal and
outer journal.
Your table needs to be something like this --
PartNum Item Use
Wad123 Bearing Inner
Wad124 Bearing Outer
Saq234 Bolt 1/4 X 20 X 4 1/2
 
I'm not using a form to call the reports
How do you distinguish between the two different reports with only one?
 
Back
Top