[AccessD] Another normalization question

What's wrong with having numbers at both levels ?
In addition it might be helpful to have a "personal phone" indicator for the
contacts to identify the office phones from those held by the contact.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Tuesday, September 16, 2014 3:14 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Another normalization question
>
> I'm still working on the animal tracking database. It's going Okay, but
> I
> don't have a lot of free time to work on it. ;)
>
> Right now I'm hashing through institution contacts and phone numbers. I
> think, for the most part, that most phone numbers will belong to the
> institution, but maybe not -- what if the institution has more than one
> contact and each has a number? On the other hand, if I relate the phone
> number to the contact and the contact leaves, I lose the phone number,
> which might rightly belong to the institution.
>
> You know, looking back... I can't remember how I handled this in the
> past.
>
> Susan H.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com