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
