Doh! Thanks Sami. I had this working fine in Access so knew it wasn't the table structure. Thanks to all who replied. Lucas
> 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 >> >> > >
