[AccessD] A database design for contacts....

Jim Dettman jimdettman at verizon.net
Wed May 9 14:37:15 CDT 2007


Hi All,
 
  In light of recent discussions on lookup tables, I'm curious on how
different people have attacked the contacts problem.  For example, let's say
I need to keep track of Doctors, Attorneys, Therapists, Hospitals, Clinics,
etc.  A contact could be an individual or a group or company.  For example,
I might have three doctors working as  a group called Plank Road Medical.
You need to keep track of both the individual doctors and their contact info
and the contact info for the group.  Also the fact that they are all
associated.
 
  Do you:
 
A. Have a table for every possible type of contact? 
 
or 
 
B. Have one contact table which includes a contact "type".
 
 
  and the second question; how do you handle companies vs. individuals and
link the two?  Do you:
 
A.  Have a separate table for companies. 
 
B.  Have a flag which indicates if the contact is a company or an individual
and self-join to your single table.
 
 
  I know the right answer, but I'm wondering what everyone feels is the
practical answer.  Given the recent thread on Lookups, this is probably a
good topic for discussion.
 
Jim.



More information about the AccessD mailing list