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 > >
