Find Record from Subform

[ecklers]

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.

 

[John Welch]

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?

 

[ecklers]

Yes, that is the goal for the end user.

 

[darkroomdevil]

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