I've got a pick list that is using a LOOKUP() function in one of the columns. The problem is that I wan to index on that field. We have been able to index on LOOKUP() functions before but that would be only if we were using a view in the pick list, which we are not. We need to see all records in the pick list but this view takes much too long because of the number of records.

We could actually override VMP's seek in the lookup form but I still could not have this column sorted. We have thought of having two grids. We have also thought of making the LOOKUP a permanent index. Neither of these solutions is very appealing. Please Help Me. :)

TIA