Search Data betwenn 2 tables that have manay to many relationship

[AmrutaKar]

I have 3 tables.

1) Customer Table

2) Accounts Tabble

3) Customer_Accounts Table

One customer could have many accounts and simmilarly One account could have multiple customers. for eg

Customer Table

customerID	customerName
1	A
2	B
3	C

Accounts Table

accountID	accountName
4	ABC
5	DEF
6	GHI

Customer_Account Table

customeraccountid	customerID	accountID
1	1	4
2	1	5
3	2	6
4	3	6

There is a  relationship between Customer Table , Accounts Table and Customer_Account_Table.

I have to create a dashboard where if I search for customer in the customer table, I should get the Accounts it belongs to from the Accounts table and simmilarly, if I search for Accounts in the Accounts table , I should get all the customers that belong to that account.

Could you please tell me how can I achieve this.

Thanks

[Jimmy801 · Accepted solution]

Hello @AmrutaKar 

you have to set the cross filter direction to "both"

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy