Results 1 to 2 of 2
  1. #1
    sloft21 is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    1

    Database Design/Relationships

    I have to follow steps 1-5 based on the model shown at the end and using my own made up numbers. I've entered the tables but I'm not sure if they are right and when I tried to set the relationships it wouldn't allow me to change the type of relationship, for example from 1 to many to 1 to 1, etc. could someone help me out because I'm kind of lost on step 3 and 4? Thank you!
    Attached Files Attached Files

  2. #2
    live2ride is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2012
    Posts
    70
    you need primary and foreign keys
    example

    tblRestoraunts ID as primary key, Names as string
    tblMenu ID as Primary Key, RestaurantID as Integer Foreign Key

    for you add records to tblRestaurants
    PK 1, Name as BurgerKin
    PK 2, Name as McDonalds

    recs to tblMenu
    ID 1, RestaurantID 1, Name as Whopper
    ID 2, RestaurantID 2, Name as Fish

    Relationship is
    tblRestaurants.ID to tblMenu.RestaurantID

    this way Access knows that Whopper is BurgerKing and Fish is in McDonalds

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help with table and relationships design
    By blinton in forum Access
    Replies: 1
    Last Post: 04-25-2012, 07:51 AM
  2. Database relationships
    By radex7 in forum Database Design
    Replies: 10
    Last Post: 03-07-2011, 05:07 PM
  3. Help with Join Relationships in Design View
    By robintmathew in forum Access
    Replies: 8
    Last Post: 02-11-2011, 10:59 AM
  4. Table design and relationships
    By CoachBarker in forum Database Design
    Replies: 1
    Last Post: 10-01-2010, 11:22 AM
  5. Table Design & Relationships
    By mastromb in forum Database Design
    Replies: 16
    Last Post: 12-30-2009, 10:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums