Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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. OP
    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.
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page