Subject lookupsql and Combobox ; where is the missing link
From Dirk <>
Date Fri, 29 May 2020 22:26:54 +0200
Newsgroups dbase.getting-started


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

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