RE: in need of guidance ...

On Wed, October 11, 2006 6:40 pm, Michael McBride wrote:
> Walter:
>
>
> How are mail stops different from, say, a box number.
>
> As far as I can tell,
>
> 123 Penguin Place, MS87
>
> shouldn't be any different from
>
> 123 Penguin Place, Apt 87.

One level they're not.

2 contacts:
  Mark and Nancy McGee
  123 Penguin Place, Apt 87.
  Somewhere, USA 12345

In my "world" they have seperate "contact" records but share share the
same address record (street, etc).

But mail stops (usually) refer to a group of people within the same
devision of a company.

 Mega Corp
 Mark McGee
 123 Penguin Place, MS 87
 Somewhere, USA 12345

 Mega Corp
 Mark McGee
 123 Penguin Place, MS 87
 Somewhere, USA 12345

 Mega Corp
 Alice Cooper
 123 Penguin Place, MS 23
 Somewhere, USA 12345

3 contacts records, 1 address record, 2 mail stops and 1 company record.

Both contact and company record refer to the same address record.

I figure the mail stop data would be part of the contact record.

walter






-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]