How do I link two record sources to one form? HELP!

[a14929]

I am in the process of designing an appliction to assign books to students. On the students form, I have included the various fields from the students table. The students table is therefore the record source in the properties dialog box. However, on this form, I also need to include a checkbox "Yes/No" field from the books table. Is there a way of doing this? I am desperate, plese help!

 

[cinnamoncw]

Create a subform that goes with your main form. Link a common field between the two forms so that the records match.