[RBG7-L] - DB Grid

[Joel Solomon]

I have a form that accesses three tables;  StudentMaster, ClassMaster, Attendance.  I have set up the form with the main table (StudentMaster) and use ClassMaster and Attendance as slave tables.  I have also set up a DBGrid for each of the slave tables.   When I click on a record in the ClassMaster I want the appropriate Attendance to appear in its DBGrid.  A Common field exist between each of the tables (StuNumber).  Also, a common field exits between the two slave tables (ClassNo).   When the student record appears on the screen, I get the associated ClassMaster records and the Attendance records that exist for the student.  I want to get the associated attendance records for the ClassMaster record that is selected in the DBGrid.  How do I accomplish this?   Joel Solomon Controller Barbizon International [EMAIL PROTECTED]