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
