echowebs wrote:
> So Ian - you are saying that I need a table of addresses and that each record
> would belong to either a peron or a business. Is that correct?
> If so - I wonder doesn't that duplicate every business address at least once?
> Since every business will have a primary address and it WILL be the exact same
> as the primary owner at all times..... hmm

No, there is no reason that the business join and the person join can
not point to the exact same address record. This actually illuminates
duplicate records that would occur in just about any other scheme.


bus1, 'My Place of Business'...
per1, 'Mary Sue Von Der Longname', ...
add1, '123', 'Main Street', 'My Town', ...

Business Join
bus1, add1

Person Join
per1, add1, 'year around'