Hi Tony, Thanks very much for that. I have changed the setting as you suggested. My 'problem' is now solved. I appreciate your help.
Regards John Docherty On Tuesday, March 26, 2019 at 1:30:32 AM UTC+13, Tony IJntema wrote: > > John, > > > > Take a look at the table relations in the form. > > > > > > I think the setting of Many to Many is the one you have to choose to > achiev the result you want > > > > Tony > > *Van:* [email protected] <javascript:> <[email protected] > <javascript:>> *Namens *John Docherty > *Verzonden:* maandag 25 maart 2019 13:16 > *Aan:* RBASE-L <[email protected] <javascript:>> > *Onderwerp:* [RBASE-L] - Scrolling Regions > > > > Hi, > > > > I have a form with three scrolling regions and three tables - master and > two slaves. There are common columns which link the data, which represents > data in three tables, SECTIONS, SUB_SECTIONS & SUB_SUB_SECTIONS. > > > > While when I scroll through the SECTIONS region only the rows for the > matching SUB_SECTION & SUB_SUB_SECTION are displayed. However when I scroll > through the SUB_SECTION region, all of the rows that match the SECTION > number appear in the SUB_SUB_SECTION region. However all I want to appear > are the rows that match the SECTION NUMBER and the SUB_SECTION NUMBER. I > thought that this used to happen, but maybe my memory has failed in regard > to that. > > > > The attached screenshot hopefully shows what is happening. The cursor is > on a row with a subsectn no of 6, for which there are no rows in the > SUB_SUB_SECTION table, however rows from that table are displayed. > > > > Any suggestions as to what should happen and what I have wrong would be > much appreciated. (I am using X.5 10.5.1.30214.) > > > > Thank you. > > > > Regards > > > > John Docherty > > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/d/optout. > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
