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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering data with many to many relationship 1
data input form for tables with many to many relationship 1
Linking form to sub form in Office 2007 2
Many to Many on a form 1
One form with many questions 4
Forms to enter data 1
Form with one-to-many rows 1
one to many relationship 3

Back
Top