Geoffrey, And to add to Jim's response, if there are values in common columns that are not the same, these rows will not appear. (I suspect that may well be why you are not seeing all of the data you are expecting to see.)
Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of James Bentley Sent: Wednesday, 28 October 2009 11:13 p.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: One to Many DB Grid Form Geoffrey, Check to see if there are additional common column names beside your stated linking column name(s). In the "Mother/Daughter" relationship all common column names participate in determining is the "Daughter" rows should be linked. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ----- Original Message ---- From: Geoffrey Wheeler <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, October 28, 2009 5:03:03 AM Subject: [RBASE-L] - One to Many DB Grid Form I have a Form that I've set up like the OneToManyDBGrid form in the CONCOMP sample database that came with Rbase 7.6. It's not working in that for the One in the Master table many of the rows in the slave table fail to appear in its DBGrid. This Form arrangement works for other Master/Slave (I think Mother/Daughter would be a nicer aphroism) tables. It appears to me that I have a corruption in my Database somewhere. I tried unloading and loading data and structure for both the Master and Slave tables but this did not have an affect. Do I need to look at some system tables? I can create a view between the 2 tables. Anything I might be overlooking in my form design? Thanks, Geoffrey in Thailand
