When using the PICK FROM statement, it displayed a list based on the WHERE of the statement and it is working great.
My only problem is the "columns I want displayed" are not and I can't for the life of me figure out where I set the columns I want displayed on the PICK screen.
You can define a query, say called MyQuery, in which you can specify both the necessary conditions and the attributes to display. You can then use the query name in the PICK FROM action: