||Re: lookupsql and Combobox ; where is the missing link :: Solution ::
||Sun, 31 May 2020 12:04:08 +0200
Op 30/05/2020 om 14:45 schreef Mervyn Bick:
> On 30/05/2020 11:33, Mervyn Bick wrote:
Goodday, Mervyn, Akshat
filter is working
cLand = form.vraagbak_stammdat.rowset.fields['stammland'].lookuprowset
cLand.applyLocate("land = '" +this.value+"'")
A = (cland.fields.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