[AccessD] Another normalization question

I hadn't thought of that -- it might be the simplest route. However, right
now, the interface is connecting phones to institutions, but, there's no
reason why I can't add the functionality to the contact form -- in fact,
that's sounding pretty good right now.

Susan H. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Tuesday, September 16, 2014 3:42 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com