Cascade of tables/forms

[Ramesh]

HI,

Needs some guidance to suitably create tables. I need to input students
attendance information for every week. The fields required are WeekNo,
StuID, TotalClasses, ClassAttended. There are other tables which contain
batch information. Table StudentsBatch , with fields StuID, BatchNo,
JoinDate. Table BatchInfo with BatchNo, Subject, Timing, Tutor.

Now i am trying to create a form where i can enter the Week No, select Tutor
from a list, which will list the students of the batches handled by that
tutor in a subform, where i can enter the Total classes and ClassesAttended
for the week.

Could someone guide me on doing this please?

Thanks in advance.
Ramesh