linking the tables

[NewFM85User]

Hi,

I have 2 tables Products and Delivery

Both have the columns ProductID and Product type.

The relative data exists in both tables.

Exp

Products table

ProductID ProductType

P001 LowEnd

P002 Medium

Delivery Table

ProductID ProductType

P001 LowEnd

P002 Medium

Both the tables are in different Database.

When I am in the Db containing Delivery Table, I need to link to products table. In the relations I create a table Products_Delivery and link them through Product ID and Product type. When I do that, the resultiong table has 2 records but with blank data and 0 count.

When I delete the condition Prodyct type and just keep the ProductID, The data populates in the Resulting table Products_Delivery .

What could be wrong ? I am missing some link somewhere. I need to get this data with both conditions considered.

Please advise.

Thanks

[RalphL]

I would like to see how you have set up the external data sources in both files and the relational graphs for both. Maybe you could provide a set of sample files.