Question about pick-lists in Forms*3.0

Can anyone suggest a remedy for the following:

• As you know the RESTRICT parameter in list_values(restrict) when used in a KEY-LISTVAL trigger causes the partially entered string in a field to be automatically completed if it matches with a value in the defined table of values. ex. if you enter CAN in the country field it completes it as CANADA. which is exactly what I want,

  Provided you have a statement in the "List of Values SQL Text" of   the country field like: select country_name into :A.country from   country_table

  Now you suddenly realise that you want to have a where clause added   to your criterion so you change the "List of Values SQL Text" of   the country field to: select country_name into :A.country from   country_table where GNP > 2000

  Now the partially entered country name will no longer be completed   automatically - instead a list of countries will pop-up to select from.

  So it seems that the where clause overrides the RESTRICT parameter.

  Does any body have a solution to this?   Thanks in advance,
  Kamran Derakhshan  

--