Subject Re: lookupsql and Combobox ; where is the missing link :: Solution ::
From Dirk <>
Date Sun, 31 May 2020 12:04:08 +0200
Newsgroups dbase.getting-started

Op 30/05/2020 om 14:45 schreef Mervyn Bick:
> On 30/05/2020 11:33, Mervyn Bick wrote:

  " removed

Goodday, Mervyn, Akshat

filter is working

cLand = form.vraagbak_stammdat.rowset.fields['stammland'].lookuprowset
cLand.applyLocate("land = '" +this.value+"'")
A = (cland.fields[1].value)
form.rowset.Filter = "stammland ='"+A+"'"

i putted the fieldlenghts of both felds teh same lenght : the width of
stammdat was 3  and country  was 4, that's was the main problem


  thanks for pointing me on the distinct of the countries..

   why you don't write a book as Sql and dBase :)

your remark on combobox , in my programm i use an array to fill up the

thanks again for your attention