I have, in my database, accounts which have several contacts, and some of those accounts are large enough that they have multiple divisions, and mailing addresses. For this, I use the multiple mailing address feature.
Some of these customers require that a room number be included in the address, so for some of my accounts, I have many (many) addresses, each of which point to a particular office in the account.
When a contact is removed from my database, though, and the particular address (maybe an office) is no longer in use, I don't see a way to maintain those addresses such that the addresses for a particular account don't get out of hand.
I would think that when a contact is removed, and it's the only contact that uses a particular address, then the address would also be removed (or at least I'd be prompted about the orphaned address) No such luck. So, now I have accounts with dozens of addresses - floors and offices, but I don't know if they're in use by any of my existing contacts at the account. And, it complicates the addition of another contact, because I don't know if I can re-use a 'specialty' address, or if I have to create yet another one, or if a particular address already exists.
Am I misunderstanding the functionality, or is there a solution to this dilemma?
Original Post