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
