Results 1 to 8 of 8
  1. #1
    reverze is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    31

    many-to-one relationship

    I want to create a many-to-one relationship but for some reason it won't work out.

    It keeps having the relationship in the opposite order.

    I want the inifinity symbol and 1 symbol in reverse order.

    How can I create a many-to-one relationship?

  2. #2
    reverze is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    31
    bump

    I hope this isn't a very dumb question.

    I just don't get why it always shows one-to-many and not many-to-one..

  3. #3
    reverze is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    31
    bump...anyone?

  4. #4
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,170
    Reverze,

    there only exist:
    * 1 to 1 relationships,
    * 1 to many relationships
    * and many to many relationships which are broken into 2 1 to many relationships.....

  5. #5
    reverze is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    31
    So, it dosen't matter what way the relationship is facing?

    The symbol for the many and the symbol for the one are in the wrong order in my diagram.

  6. #6
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,170
    You could move one of the tables to the other side of the other table in your diagram?

  7. #7
    reverze is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    31
    That won't work..

    Not quite sure if I'm explaining this correctly lol.

    PS. you're from Belgium? Which beers do you like?

  8. #8
    ConneXionLost's Avatar
    ConneXionLost is offline Simulacrum
    Windows XP Access 2003
    Join Date
    Jan 2010
    Location
    Victoria, Canada
    Posts
    291
    A one-to-many relationship is usually established by using a Primary Key from one table as a Foreign Key in another table. The table with the Primary key will always have the "1" symbol displayed on the relationship line.

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

Similar Threads

  1. One to one relationship
    By ManvinderKaur in forum Database Design
    Replies: 2
    Last Post: 06-28-2010, 05:37 PM
  2. one to many relationship?
    By cowboy in forum Access
    Replies: 3
    Last Post: 06-16-2010, 02:37 PM
  3. Relationship
    By pcandns in forum Access
    Replies: 2
    Last Post: 04-01-2009, 09:32 AM
  4. Many-to-Many Relationship
    By Carolyn1 in forum Database Design
    Replies: 0
    Last Post: 09-25-2006, 02:04 PM
  5. MAY TO MANY RELATIONSHIP
    By fadone in forum Database Design
    Replies: 2
    Last Post: 12-20-2005, 09:03 AM

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