Subject lookupSql and applylocate From Dirk <non@non.com> Date Wed, 18 Jan 2023 23:05:00 +0100 Newsgroups dbase.getting-started Dear all, i use a sql with lookupsql working well   sorting no probleme when i sorted i want to find the row needed, with field not based on a lookupsql no problem when i want to search a row with a field based on lookupsql i have to put the value of this row like : in query the field is "000006" = in the productquery "transmission how to get when in the searchfield teh value transmission is filled in Function VELD_ZOEK_onKey(nChar, nPosition,bShift,bControl)     local cZoek, vraagbak_sort        vraagbak_sort = this.parent.vraagbak_type         do case         not working             case this.parent.keuzedoos_kiezen.value =="aandrijfwijze"             vraagbak_sort.rowset.locateOptions = 3                 vraagbak_sort.rowset.beginlocate()             cZoek = "aandrijving='"+trim(this.value)+"'"              vraagbak_sort.rowset.ApplyLocate(cZoek)             Case form.keuzedoos_kiezen.value =="krachtbron"                          vraagbak_sort.rowset.locateOptions = 3                 vraagbak_sort.rowset.beginlocate()                       cVeld = "krachtbron='"+trim(this.value)+"'"               vraagbak_sort.rowset.ApplyLocate(cVeld)          case form.keuzedoos_kiezen.value =="merk"                          vraagbak_sort.rowset.locateOptions = 3                  vraagbak_sort.rowset.beginlocate()                        cVeld = "merkid='"+trim(this.value)+"'"                vraagbak_sort.rowset.ApplyLocate(cVeld)              working              case form.keuzedoos_kiezen.value =="type"                vraagbak_sort.rowset.locateOptions = 3               vraagbak_sort.rowset.beginlocate()               cVeld = "type='"+trim(this.value)+"'"                vraagbak_sort.rowset.ApplyLocate(cVeld)         endcase    Return thanks for a push in right direction regards Dirk,