NewFM85User Posted January 23, 2009 Share Posted January 23, 2009 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 Link to comment Share on other sites More sharing options...
RalphL Posted January 23, 2009 Share Posted January 23, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5565 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now