----- Original Message -----
Sent: Friday, July 02, 2004 12:54
PM
Subject: [RBG7-L] - Re: DB Grid
Joel
Have you set up the form relationships as ONE to
MANY or MANY to MANY. I beleive you want MANY to MANY for this situation.
(Form Properties / Table Relations / Many to Many)
Look at the sample form ManyToManyTabForm in
CONCOMP - edit using it and on the first tab, click on RAM DATA Systems (the
last in the list). Then click on the Master Transactions form - if you
clickon the first transaction in the grid, then click on Detail Transactions,
you see the details for that transaction. If you click on the SECOND
transaction on the Master tab and then click on Detail, you'll now see the
transaction details for the second invoice. This sounds like what you
want.
David Blocker
----- Original Message -----
Sent: Friday, July 02, 2004 11:11 AM
Subject: [RBG7-L] - DB Grid
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?
