Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Design issue (XP)

    I

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Design issue (XP)

    >>Problem is, how do I set up the many to0 many relationships? <<

    You set-up a many-to-many relationship between tables by creating what is sometimes called a "resolver" table (goes by other names as well). In your case, you will have tblURL and tblCategory; in which 1 URL can have many categories and each category can have many URLs. Your tblCategoryURL merely contains 2 fields, the primary key field from each of the other tables. So, the resolver table is then the "many" side of 2 one-to-many relationships, one with each of the other tables.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •