Hello Community!
I have a client who would like to see other accounts that are in the same country/city as the current account.
Example:
Account A is located in Boston, MA, USA
and so are Account G, Account J, and Account Y.
How would we fill out a detail filtered by "current Account Country/City" on the Accounts section/object, so that Account A will have a reference to Account G, and Account J and Account Y because they are all located in Boston, MA, USA?
On the opposite side:
Account G would have a reference to Account A, Account J, and Account Y.
Account J would have a reference to Account A, Account G, and Account Y.
Account Y would have a reference to Account A, Account J, and Account G.