Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jun 2010
    Location
    Atlanta
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a main form (A) which shows the issue that a department has been dealing with. I have subform called resolution activities(B) and is continuous) that shows what is being done to remedy the problem and is linked to the A by Issue ID. I want to create another subform called comments (C) that is nested within B and is continuous and will list comments and dates of comments that is being done on the resolution(B). What is the best way to sync these forms?

  2. #2
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    You can nest a subform in the subform in exactly the same way.

    You should have three tables -

    tblIssue (with IssueID being the primary key),

    tblResolutionActivitiy (with ActivityID being the primary key and IssueID as the foreign key that establishes the relationship with tblIssue)

    tblActivityNote (with NoteID as the primary key and ActivityID as the foreign key that joins to tblResolutionActivity)

    So just as you used IssueID to establish the Child / Parent relationship between the first subform and the parent form, you would use ActivityID as the Link Child and Link Master fields.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    When you put a continuous subform within another continuous form, Access says it can't be done and changes the form to a Single form.

    To get around this you need to put the second subform within the form footer or header of the first subform, then change it back to a continuous form (via the properties box).
    Regards
    John



  4. #4
    New Lounger
    Join Date
    Jun 2010
    Location
    Atlanta
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That works and thank you very much.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    Neat trick -thanks John, I'd always had to go to single view for the first subform.

Posting Permissions

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