[AccessD] Another normalization question

Create a one--many linked Contacts table.  You can add a date field for "Inactive Date" on the Contact record to go along with name, department, phone number, email address, whatever.  If it Inactive Date gets filled in, you will know the contact is inactive as well as when the contact went inactive.  You can then filter on this field to only show/report on active contacts.  Then you will not lose any potentially important numbers.





John Bodin

jbodin at sbor.com



________________________________________
From: accessd-bounces at databaseadvisors.com <accessd-bounces at databaseadvisors.com> on behalf of Susan Harkins <ssharkins at gmail.com>
Sent: Tuesday, September 16, 2014 3:13 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