I am trying to design tables for a database using Access 2003 that will
allow me to retrieve information about Bible study contacts. I had a pretty
good concept on how to do this dealing with individual contacts but now I
realize that some of my studies with people will involve several contacts at
once, some having the same address but different phone numbers and email
addresses. I am trying to sort out what type of tables I need to get the
job done where when I look for active studies that I can see all related
Do I need to have one table with just ContactID and ContactFirstName and
Lastname and then split off the Contactaddress table because more than one
contact can have the same address and I do not want to retype that
information of course.
As always, I am probably not explaining it as clearly as possible but to
summarize my database is composed of following contact information (name,
address and so on), visitor information (how often they have visited with us
to worship) and study history information (time of study, topics studied and
their responses to those studies). Your help is always greatly appreciated.