I have a view that I use for keywords. The first column is sorted and categorized on the field name. The second column is sorted on the value and the third column is sorted on the code for that value. There is a fourth column that contains both the code and the value which is what I return with the @Picklist function. The problem I am having is that sometimes when in the Picklist window, the user uses the Starts with… feature to find the value and uses the Search Within Category it works for one field, but does not work for other fields. Is there some limitation to the Search Within Category button??
Subject: Picklist Category Search
Did you see this…
Number. A number indicating which column value you want @PickList to return. Use 1 to indicate the first column, 2 to indicate the second column, and so on. Unlike @DbColumn and @DbLookup, @PickList counts all columns, regardless of the types of formula they contain.
Subject: Also you might…RE: Picklist Category Search
Use an @Prompt to get the column uses want to seach.
Subject: RE: Picklist Category Search
Here is the code.
view := “vwProdAll”;
title := “Brands”;
prompt := “Please choose a Brand from the list”;
choice:=@PickList( [Custom] : [Single] ; ConfigDBServer:ConfigDBFilePath ; view ; title ; prompt ; 4 ; “Brand”);
FIELD Brand := @Word(choice;“~”;2);
FIELD BrandCode := @Word(choice;“~”;1);
I am not having any problems with the return value. Sometimes the picklist will have 30 or more values to choose from and instead of scrolling the users would like to use the type ahead feature to get to the value they want. The Search Within Category button that shows in the Starts With… dialog works for some Picklists, but does not work for others and all the picklists are using the same view and code above, with just the category changing.
Subject: RE: Picklist Category Search
For those indivduals not working; could it be a view access problem? For those not working, can they return ANYTHING? Or just certain columns?
Subject: RE: Picklist Category Search
It is the same individual, same columns, just different categories being pulled into the picklist
Subject: RE: Picklist Category Search
I’m stumped. Sorry Kevin!
Subject: RE: Picklist Category Search
I had the same problem.The problem is dat if the user sorts on another column to look for a value the view is getting another way of sorting.
Making a copy of the view and get the results from that view did the trick for me 
A little bit late, but could be usefull for others I hope