Jay Have you set the relationship to MANY to MANY instead of the default ONE to MANY (See the Form properties control, button "Table Relations")
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "J BLAUSTEIN" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, February 10, 2005 1:56 AM Subject: [RBG7-L] - Problem with forms and related sub rows > I am programing a three level form and have found some problems with > related sub rows. > common columns > level 1 = vendor invoice vendorid venlineinvid > level 2 = agency invoice vendorid venlineinvid agencyid agylineid > level 3 = g/l distribution vendorid venlineinvid agencyid agylineid > > when running it under v6.5 - only rows related to the level 1 appears in > level 2 and rows related to level 2 appear in level 3 > in addition when I add a row in level 3 all the related level 2 information > appears. > > under v7.1 latest download all rows appears between level 2 and level 3 > whether related or not if they have a common relationship with level 1 > > Has any one experience the above? > > Is there something I am doing wrong regards to v7.1 > > thanks > > J > > >
