one to many relationship

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

Guest

I have 2 tables that are attatched by a one to many relationship. What I am
wanting to do is be able to pull up a person(my one table) by name and date
of birth, once they are pulled up, I want to be able to enter a test for
them(my many table) and then save. My question is would I be able to do this
using a subform. Basically the one table will already have the person in it
and I don't want them to change that, but I want users to enter the tests
these people do. Any suggestions. I know this is probably very simple but not
for me today.
Thanks for any help.
Amy
 
Main form based on tblPerson

Subform based on tblTest
Link Child Field: Person key value in tblTest
Link Master Field: Person key value in tblPerson
 
Hi Amy

You can set the Locked property for all the fields on your main form that
you do not want users to change. They will still be able to add records to
the subform.

You might also want to turn off the AllowEdits and AllowDeletions properties
of the subform, so that they can add new test data but not modify existing
ones.
 
Thank you to all that responded. Yes, you helped a great deal. I couldn't
remember the inheritance from parent form to subform. It was one of those
days. Thanks to all who helped you made this day a much better one for me..
Thank you,
Amy
 
Back
Top