Find Record from Subform

Hi All-

I have a database that is storing contractual data for a Martial Arts
school.

I have two primary tables working together here. tblGuarantor and
Students.

I have a form to store guarantor data with a subform to add new
students in a one to many relationship.

I have a continuous subform that can add new students and assign a
guarantorid to the student.

My question exists that if a student already existed without a
guarantor, is there a way I could search on student records and assign
them to a guarantor?

Thanks in advance for any help.

You can open the students table and sort it by guarantorid and then type in
the guarantorid by hand, but this sounds too obvious, so perhaps i am
missing something. Do you want to be able to do it via the forms?

wrote in message
oups.com...
Hi All-

I have a database that is storing contractual data for a Martial Arts
school.

I have two primary tables working together here. tblGuarantor and
Students.

I have a form to store guarantor data with a subform to add new
students in a one to many relationship.

I have a continuous subform that can add new students and assign a
guarantorid to the student.

My question exists that if a student already existed without a
guarantor, is there a way I could search on student records and assign
them to a guarantor?

Thanks in advance for any help.

Yes, that is the goal for the end user.

it sounds like only one guarantor per student / many studesnts per guarantor,
if that is the case, have a form that is the students information on which
resides a dropdown list box where the user would see the guarantor, change
the guarantor or select the guarantor ...