Subject Filter on 2 fields with lookup From Dirk C <dirk@C.com> Date Mon, 25 Mar 2024 23:05:03 +0100 Newsgroups dbase.getting-started Hello, want to filter on 2 fields wirh a lookup field i am trying to put the first filter as a variable and using for the second filter   function KEUZEDOOS_SOORTEN_onChange()     local cSegm, cS, cMomentFilter     this.style = 2      cSegm = form.vraagbak_stammdat.rowset.fields['soort'].lookuprowset    //soort       cSegm.applyLocate("description = '" +this.value+"'")   // description        cS = (cSegm.fields[1].value)         form.rowset.Filter :=[soort =']+cS+[']         cMomentFilter= form.rowset.filter            cLand = form.vraagbak_stammdat.rowset.fields['country'].lookuprowset           cLand.applyLocate("land = '" +this.value+"'")            A = (cland.fields[1].value)           form.rowset.Filter := cMomentFilter + "country ='"+A+"'"    return    **** thanks Dirk