Susan Harkins
ssharkins at gmail.com
Tue Sep 16 17:45:13 CDT 2014
You bring up a point I hadn't considered -- inactive folks. Thank you! Susan H. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bodin Sent: Tuesday, September 16, 2014 3:49 PM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com