Forum Discussion
Issues with relationships
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
Solution SageCan 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.