Jump to content
Sign in to follow this  
NewFM85User

linking the tables

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.