one to many relationship

A

amy14775

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
 
B

Bill Edwards

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
 
G

Graham Mandeno

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.
 
A

amy14775

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
 
Top