Forum Discussion
Issues with relationships
Do you have one record only for each customer in each table ? You should be able to extract a table of customers, with one record for each customer and then create relationships between that and table 1 and table 2. If you don't want to filter for the same date in both tables you might need to have one calendar table for each of them.
Hi kentyler
No, is not 1 record per customer, there is actually around 500k rows but only around 200 buyer names, so there is alot of lines for the same buyer name, and that is my problem, that i cannot filter everything on the same page with 1 data, thats what i've been trying to do, but for some reason the relationship that im making is not working, and its for obvious reason a many to many relationship
Can you extract the distinct buyer names into a table. Then that table should be in a 1 to many relationship with both table 1 and table 2
Unfortunately no, i cannot, because there is no buyer name on one table, so there is no way to create a relation with that data.
I have tryied to remove the buyer name and buyer code, so i will have almost the same columns, but still not working, im only able to filter 1 table with the date or the region at the same time.