entering data in a form for a one to many relationship

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with people, with each person having a unique ID, and person
information. Then there is a table with courses. Each row is supposed to have
the ID of a person from the person table, and the name of the course, and
other course information. The tables are linked in a one-to-many
relationship.

I'm trying to enter person-course information using forms. I have a main
form where I enter the person information, and a subform where I enter the
course information. When trying to enter data into the course subform, it
fails to automatically fill in the person ID of the current record. I get the
following error message: "the plinkmasterfields roperty setting has produced
this error: the object doesn't contain the automation object "persontable".

Wow... can anyone help with this?? Thanks a million!
 
I'm assuming both tables have a field called PersonID, and that it is the
primary key in the people table. In the "link master fields" and "link child
fields" properties of the subform control, do you have PersonID?

-John
 
Back
Top