Jason,
Just to clarify, the same address can be associated to both a set of
users and a set of companies, so if I change the address for company
A, that could potentially change the address for companies B and C and
users A, B and C (who presumably don't work for company A or B
otherwise
Do you need to store any info about the relationship? Or just the fact that
it exists? If you're OK simply knowing that the relationship exists, you
can create a m2m relationship from Company to Address, which will manifest
in a table with 2 columns - CompanyPK & AddressPK.
On Wed, Oct 28, 2009
I have an Address object. I also have a Company object as well as a User
object. Both Companies and Users can have addresses. Users may have the
same address as their company. Each Company can have several Users.
In the "old days" of SQL, I would establish a join table between Company
(with a