Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    34

    Unanswered: A simple question

    Hi,

    I want to store the details of people and their contact details, but I am not sure how to go about it. I need the database to be able to link people who have the same contact details together, e.g. Mr and Mrs Smith live together, so I only want to store their contact details once in the database. This is what I have so far:

    Person Table:
    Member ID (Primary Key)
    First Name
    Last Name
    Date of Birth

    Contact Table:
    Flat/House No.
    Street Name
    Suburb
    Town/City
    Phone No.

    Phone No. could be a PK of the Contact table, but so could (Flat/House No. & Street Name & Town/City).

    What is the best way to do this?

  2. #2
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    Hi
    May I suggest that a look in the Access Database ready mades for the Contact Management - this might have the required advice or indeed be what you looking for and save a mountain of time


    rgds
    gareth

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •