Linking two columns from one table with one in another?

[RSW]

I am trying to link two databases that were developed independently.

A simplified example: one has an ASSEMBLY table like this:

AssemblyID
WidgetA-ID
WidgetB-ID

and another has a WIDGET table like this:

WidgetID
WidgetType

I'd like a query that would report this:

Assembly ID, WidgetA-ID, WidgetA-Type, WidgetB-ID, WidgetB-Type

I don't have the luxury of changing the way the databases are designed. Is there any way I can generate a query like this in Access?

Thanks in advance!

 

[jdraw]

What is it that links WIDGETS Band ASSEMBLY.

 

[boblarson]

In the Query By Example Grid (QBE) just add the second table twice and then link one to WidgetA and link the other to WidgetB.

 

[RSW]

In the Query By Example Grid (QBE) just add the second table twice and then link one to WidgetA and link the other to WidgetB.

Thanks, I didn't know you could add a table twice!