>I am using a SELECT-SQL to fill a combo box and using a property of the combo box to filter out only certain records. There will be several of these combo on the form, each selecting a different subset of a lookup table and I want to get away with using just one instance of the lookup table in the data environment
Hi Peter,
I had the similar problems, when I wanted to restrict one multiselect grid depending on choices in another... Take a look at my class
1222 Container with MultiSelectGrid in Classes/VCX for some ideas.
Basically, I use variable (as other suggested to you as well) and do
selectcmd="where &lcWhere into cursor curTowns" (something like that).
If it's not broken, fix it until it is.
My Blog