Lucas, Also check of the subtables have additional common column names besides Primary and Foreign Keys. RBase uses all common column names in determining whether a subtable matches.
Jim Bentley [EMAIL PROTECTED] --- Sami Aaron <[EMAIL PROTECTED]> wrote: > Lucas - > > Under Form Properties, Table Settings, select Many > to Many. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Sami Aaron > Software Management Specialists > 913-915-1971 > [EMAIL PROTECTED] > > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Steve Vellella > Sent: Thursday, September 29, 2005 11:46 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Table limit on forms? > > Lucas, > > Sorry, I can't say that I have seen that sort of > behavior. > > Steve > > Steve Vellella > Office: 520-498-2256 > Cell: 520-250-6498 > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Lucas > Edwards > Sent: Thursday, September 29, 2005 9:49 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Table limit on forms? > > I guess I should've explained it better Steve. > My problem seems to be that the 3rd & 4th tables > always show *all* > the data regardless of which rows are selected from > the first 2. > Lucas > > > Steve Vellella wrote: > > Lucas, > > > > My past experience with multi-table dbgrids showed > that any common > > column names in the tables have to have matching > data or the dbgrid > will > > not show any data. > > > > I have a 3 page tabbed form with 10 tables using > dbgrid, so it is not > a > > table limit. > > > > Steve Vellella > > Office: 520-498-2256 > > Cell: 520-250-6498 > > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] > On Behalf Of Lucas > > Edwards > > Sent: Thursday, September 29, 2005 9:12 PM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - Table limit on forms? > > > > A quick question... > > I've got a form based on a table called: > > > > Client > > ------ > > PK IdNo > > > > 3 other tables are added to this form: > > > > ClientDay > > --------- > > PK ClientDayID > > FK IdNo (Client) > > FK DayID (Day) > > > > ClientDayItem > > ------------- > > PK ClientDayItemID > > FK ClientDayID (ClientDay) > > FK MealSubItemID (MealSubItem) > > > > ClientDaySubItem > > ---------------- > > PK ClientDaySubItemID > > FK ClientDayItemID (ClientDayItem) > > FK SubItemDetailID (MealSubItemDetail) > > > > If I drop 4 DBGrids on the form, one for each > table, only > > the one based on ClientDay seems to link back > properly, even > > though all the tables have PK/FK relationships. > > > > Is there a 2 table limit for this sort of thing? > > > > Thanks > > Lucas > > > > > > Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
