Hi,
I have a clients table which have one to many connection with the Departments table and the Clients table also have one to many connection with the Plans table.
When Iam trying to get the data into a Table visual from all the three tables, it's not working as the relationship should be many to many.
How to solve this using TreatAs by creating the virtual relationships.
Thanks
I have a clients table which have one to many connection with the Departments table and the Clients table also have one to many connection with the Plans table.
When Iam trying to get the data into a Table visual from all the three tables, it's not working as the relationship should be many to many.
How to solve this using TreatAs by creating the virtual relationships.
Thanks