Subject what's the missing link to this grid behavior
From Dirk <non@non.com>
Date Wed, 13 Apr 2022 17:59:04 +0200
Newsgroups dbase.getting-started

Hello,

when i Filter data, i only get the first row in the grid, by navigation
i can continou browsing when datalink grid = vraagbak_Firma.rowset

when i change the datalink to vraagbak_bezoek i get all the dats of the
persons in the range , like  date >= 01/01/2015  and date <= "15/01/2021

using the query bezoek as parent en firma as child

what i am missing here
thanks to put me on right way

Dirk

function knop_aanvang_onClick
    local dStart, dEinde, volgnr
     dStart= (form.keuzeveld_begin.value)
      dEinde=(form.keuzeveld_einde.value)

      this.parent.vraagbak_bezoek.params["Start"] = dstart
       this.parent.vraagbak_bezoek.params["Einde"] = dEinde
   this.parent.vraagbak_bezoek.requery()
        this.parent.rooster_info.datalink =
this.parent.vraagbak_firma.rowset


   this.VRAAGBAK_BEZOEK = new QUERY(this)
    with (this.VRAAGBAK_BEZOEK)
       left = 210.0
       top = 187.0
       width = 92.0
       height = 37.0
       database = form.databank_klanten
       sql = "Select idnummer, visit, time1, time2  from visit where
visit >= :Start and visit <= :Einde order by visit"
       Requestlive = false
       params["Start"] = {}
       params["Einde"] = {}
       active = true
    endwith

    with (this.VRAAGBAK_BEZOEK.rowset)
       onNavigate = class::ROWSET_ONNAVIGATE
       autoEdit = false
    endwith

    this.VRAAGBAK_FIRMA = new QUERY(this)
    with (this.VRAAGBAK_FIRMA)
       left = 126.0
       top = 286.0
       width = 84.0
       height = 37.0
       database = form.databank_klanten
       sql = "select idnummer, name, plz, city, soort, outside from
stammdat where idnummer = :idnummer"
       requestLive = false
       params["idnummer"] = ""
       masterSource = form.vraagbak_bezoek.rowset
       active = true
    endwith

    with (this.VRAAGBAK_FIRMA.rowset)
       with (fields["soort"])
          lookupSQL = "select segcode, description from segm"
       endwith
       with (fields["outside"])
          lookupSQL = "select  afkorting, name from employee order by name"
       endwith
    endwith