Hi everyone,

I would like to use a SQL query datatype in a FORMS Prevalue source. The query generates a filtered list of "KEY" and "LABEL" entries.

I know, that I could use the FORMS prevalue SQL-Picker, but this would generate too many useless entries, therefore I need to pre-filter the results.

Now, I was wondering, which property editor do I have to use? When I use a nuPickers SQL (no matter, which), I get on the FORMS prevalue settings only ID and Value:

ID xxx Value {"(connection string)"}
ID xxx Value csv

I would be happy, if you could let me know, how I can get the actual query results in the prevalue source...

Best regards, Simeon