Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    3

    Unanswered: form/subform help

    I have a database with the basic structure

    Course ID (PK)
    Course Name
    ...

    Lesson Plan ID (PK)
    Lesson Plan Name
    ...

    Course-Lesson ID (PK)
    Course ID (FK)
    Lesson Plan ID (FK)

    I am trying to design a form that will allow the user to select a course name from a drop down combo box and then in a subform pull down up to 10 lesson plans so that they are assigned to that course. I was able to have the course combo box in the main form display the current lesson plans already assigned to it in the subform, but when adding a new record in the subform it just stores the lesson plan i choose as a new record in the lesson plan table, not in the course-lesson table. Attatched is my db, thank you for your help and if i am unclear or have not given enough information please let me know.
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Cool

    Here you go.. I havce updated your application
    Attached Files Attached Files

  3. #3
    Join Date
    Jun 2004
    Posts
    3
    it worked! thank you so much... just one question... exactly what did you do?

  4. #4
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    do a little comparison with the old one. You'll know. I created some queries to base the forms. This is the right way to update tables with many to many relationships. Also modified some of the relationships and table design.

Posting Permissions

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