Load dropdown list from file with 2 selection fields

[leomoore]

I am having trouble loading a drop down selection list directly from a table. I need to load the list with the value of one column based on the values of two other columns. I cannot really find a good description of the components of database driven selection.


Choices database file = FSTRUDC
Choice options field = SYCODE, SYUSC1
Choice Values field = SYDES1
Choice Selection critera = sycode='STAR', syusc1='COMMENTS'
Order by = SYCODE, SYUSC1

The value of SYDES1 is what should be in the drop down list, but so far nothing is in the list. I am kind of frustrated with this. Everyone else has given up and loaded them programatically, but I want to make this to work the way I think it is supposed to do it.

Any help would really be appreciated.

[Brian]

Hi Rob,

So here is the breakdown of how this works.

Choices Database File - This is the obvious one. Its the table (PF) that you want to pull from.
Choice Options Field - This is what is actually displayed in drop down. So this is what your user will see. These probably shouldn't be the same as your selection criteria.
Choice Values field - This is what is actually passed back to your program. So you can display a description by choosing it for your Options Field but actually pass a different value back to your program.
Choice Selection Criteria - This is how Profound UI selects which records to include in the drop down. This is the same as a WHERE clause in SQL. So your two conditions in your example should be seperated with an AND instead of a comma.
Order By - This is what sorts the options in the drop down.

If you would like to do a gotomeeting to walk through this, I would be glad to do it. Just let me know.