Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183

    Red face Unanswered: Relationship Problem

    I have 2 table and this is how the realtionshi was

    tblStudy, tblSite (Many to Many) One study can have many site and many site can have many study

    I have created the 3rd table to make it One to many

    tblStudy, tblImplemenation, and tblSite ( 2 one to many relationship)

    tblStudy have StudyNO as PK
    tblSite have SiteNo as PK
    tblImplementation have StudyNO & SiteNo as PK

    Now, i don't know how to create form from this relationship. Do i create form based on tblStudy PK or tblImplementation ? Pls.....Help me out here.
    Skharva

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What does the form need to tell you?

    The answer should be a bit clearer once you know your objective.

  3. #3
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183
    Originally posted by Teddy
    What does the form need to tell you?

    The answer should be a bit clearer once you know your objective.

    Well.......i want to create form where user can enter StudyInformation such as StudyNo, Name, FCO......And then the sub-form that would have the SITE information.....Study may have more the one SIte or None....
    Skharva

  4. #4
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: Relationship Problem

    Originally posted by Skharva
    I have 2 table and this is how the realtionshi was

    tblStudy, tblSite (Many to Many) One study can have many site and many site can have many study

    I have created the 3rd table to make it One to many

    tblStudy, tblImplemenation, and tblSite ( 2 one to many relationship)

    tblStudy have StudyNO as PK
    tblSite have SiteNo as PK
    tblImplementation have StudyNO & SiteNo as PK

    Now, i don't know how to create form from this relationship. Do i create form based on tblStudy PK or tblImplementation ? Pls.....Help me out here.
    Create a form that is based on tblImplementation. Make it the subform of a form based on either tblStudy or tblSite. Link the master and child fields between the two forms. They should link automatically when you drag the subform onto the main form. You will only have to display, on the subform, the field that is not included in the main form linking relationship. The field that is not included on the subform will automatically be added whenever you add a new record to the subform, even if it is not visible.

    Hope this helps.

    Gregg

Posting Permissions

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