Subject lookupsql and Combobox ; where is the missing link From Dirk <dtweet@outlook.be> Date Fri, 29 May 2020 22:26:54 +0200 Newsgroups dbase.getting-started Hello, i changes some *dbf files, using lookupsql   as far is all ok, append ad edit all good but im struggling on filter in a form by country by datalink i haven the dat in the combobox when i do the following a=this.parent.rowset.fields["country"].lookupRowset.fields[1].value i get the value a = B of Belgium changing the field to  2  i get Belgium now when i try   form.rowset.filter=[country=']+"A"+['] i get filtered by Austria when i try to use the varaible a i get a warning of course when i change teh value of the country, whatever  belgium or germany ... i get of course the the value of variable A my question is when i make a choice of a country in the combobox, how it's filtering by chosen country thanks for a help Regards Dirk