Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Unanswered: Many to many / Juntion Table

    Hi,
    I am relatively new to access so please bare with me. I have imported a excel spreadhsheet to access and I have the following fields

    Subs_name Subs_services
    Sub1 Service1
    Sub1
    Sub1
    Sub2
    sub2

  2. #2
    Join Date
    Sep 2003
    Posts
    3

    Re: Many to many / Juntion Table

    Hi,
    I am relatively new to access so please bare with me. I have imported a excel spreadhsheet to access and I have the following fields

    Subs_name Subs_services
    Sub1 Service1
    Sub1 Service2
    Sub1 Service3
    Sub2 Service2
    Sub2 Service3

    As you can see in the subs_name & subs_services I have duplicate entries as well. So in effect Sub1 is taking Service 1,2,3. I need to be able to have a query that allows me to simply show the service for a given client and conversely..I beleive i am in a many to many relationship here but with duplicate records..I am not sure how to progress from here..

Posting Permissions

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