Wednesday, 21 August 2013

many to many relationships in ms access

many to many relationships in ms access

I have a database (for a pet sitting company) containing tables for the
following:
Customers
emergency contacts
phone numbers
phone types
The phone numbers are stored in a separate table to allow for efficient
storage of a virtually unlimited number of phone numbers per customer. The
phone numbers table stores both the customer ID and the phone type ID in
addition to the primary key. My question is - is the best way to allow for
emergency contacts to have the same functionality with phone number
records to add another field to the phone numbers table "emergency contact
ID"? Or should I be storing emergency contacts in the same table as
customer (and rename it Individuals)? If so, please tell me how to create
a relationship between records in the same table.
Thanks so much, Jessica

No comments:

Post a Comment