Forum Discussion
Excel and datasbase data does not get realted.
afaque03,
The issue is related to the values. Please create a new bridge table containing all possible product name values of Append table and query table, then delete the existing relationship between append and query tables, create relationship between bridge table and append table, and create relationship between bridge table and query table.
Regards,
Lydia
AnonymousI created a spreadhseet which has all the unique product which are there in Query 1 and Append 1 and made a relation of query 1 product with spreadhseet product and spreadhseet product with append 1 product but when I use the date filter from Query 1 the value does not change it remains the same. Means nothing changes because of the filter in the table where I have the product and there values.
afaque03,
The issue could be caused by incorrect relationship, please share sample data of your tables so that I can test.
Regards,
Lydia