Subject Re: lookupsql and Combobox ; where is the missing link :: Solution :: From Dirk <dtweet@outlook.be> 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 Mervyn,   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 combobox. thanks again for your attention Dirk