I'm trying to say that Account B, C, and D are related to Account A. And vice versa.
The relationship for each account would be determined by the account owner so not all accounts are related based off location. I didn't know if the relationship had to be based off one aspect or if it could be manually determined by the account owner/user.
Right now, I have the table related to itself and the [Related Account ID] on the form. The user can specify one account that is related but not multiple. Also, the relationship only goes one way. For example, Account A could show its related to Account B but not vice versa.
