Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Red face Unanswered: can't add any records in subform

    3 tables: Course, Student, Project. Project is the associative entity.

    Course:
    PK: Course_no

    Student:
    PK: SSN

    Project:
    PK: Project_ID
    FK: Course_no
    FK: SSN

    I simply used Form Wizard to link three tables together. Course(main form)-Student & Project(subform) including all the keys in the fields for both forms. Now I can't add any records in subform. It says either: "Cannot enter value into blank field on 'one' side of outer join" or "join key of table "project" is not in the recordset."

    HELP, Thanks!

  2. #2
    Join Date
    Nov 2002
    Posts
    2

    Re: can't add any records in subform

    I got it.

    I need to include the PK filed(Course_no) from the Course table into the subform, I can hide it but that has to be on the form.

Posting Permissions

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