Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Bestpractices

Discussion in 'Information Technology' started by Andy, Nov 15, 2005.

  1. Andy

    Andy
    Expand Collapse
    Guest

    Are there any bestpractice when it comes to many-to-many relationships? I'm
    building a database and at the moment it looks like I will have several
    many-to-many relationships.

    /A.
     
  2. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    The standard solution is to add a junction table that breaks the
    many-to-many into a pair of one-to-many relations.

    Basic example:
    http://allenbrowne.com/casu-06.html

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Andy" <nes@multizite.org> wrote in message
    news:OjAmgWS6FHA.2192@TK2MSFTNGP14.phx.gbl...
    > Are there any bestpractice when it comes to many-to-many relationships?
    > I'm building a database and at the moment it looks like I will have
    > several many-to-many relationships.
     

Share This Page