Stuart McLachlan
stuart at lexacorp.com.pg
Tue Sep 16 16:45:12 CDT 2014
Some phone numbers belong to positions, others belong to people and yet others belong to the whole institution. You should differentiate them. Think about it as: Institution: Inst Name, Address, Switchboard Phone # Position - Posn Name, Bus Phone # etc Person - , Pers Name, Pers Phone #, email etc Institution/Person is one-to-many Position/Person is potentially many-to-many -- Stuart > 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 >