This will happen when you have NO common columns. The columns must have the same name to link. If you have a column with a different name on which you wish the tables to link, create a single table view with the column renamed.
--- Lucas Edwards <[EMAIL PROTECTED]> wrote: > 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 > > > > > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (cell) (250) 425-7259 (land) [EMAIL PROTECTED]
