Two subform datasheets on same form - problem

[WHardy7]

I have two tables - Subjects (History, Chemistry, Psychology, etc.) and
Books (Title1, Title2, etc.) Subjects if the Parent and Books is the
Child, linked by SubjectID.

I need a form that shows all Subjects on the left side, preferably in a
datasheet. On the right side I need to see all Books related to that
Subject. The challenge is that I need to see all Subjects and be able
to arrow key through them with the related records reflected in Books.

My problem is that a form bound to Subjects wants to limit Subjects to
one record (the current one.) Therefore, I can only one Subject at a
time.

I know that I can separate these into separate forms or use pop-ups,
but ease-of-use and intuitive design makes the single form more
desirable.

Any ideas?

Thank you,
Wayne

 

[Rick Brandt]

I have two tables - Subjects (History, Chemistry, Psychology, etc.) and
Books (Title1, Title2, etc.) Subjects if the Parent and Books is the
Child, linked by SubjectID.

I need a form that shows all Subjects on the left side, preferably in a
datasheet. On the right side I need to see all Books related to that
Subject. The challenge is that I need to see all Subjects and be able
to arrow key through them with the related records reflected in Books.

My problem is that a form bound to Subjects wants to limit Subjects to
one record (the current one.) Therefore, I can only one Subject at a
time.

I know that I can separate these into separate forms or use pop-ups,
but ease-of-use and intuitive design makes the single form more
desirable.

If you can live with over/under instead of side-by-side, you can make the
Subjects form a continuous form (not Datasheet) and then place the Books subform
in its footer. If you really want side-by-side, then embed both forms as
subforms inside an unbound Parent form. You can then place a hidden control on
the Parent form that reads the value of the current Subjects form selected and
use that as the MasterLink property for the Books subform.