how to avoid the some values in a value prompt?

[everlearner]

Hi Gurus,

I have defined a value prompt for a column, that column has 17 diff values. but i have to display only some values
for the selection. how to avoid the unwanted values in the prompt???

Thanks in adv

[charlie]

You could use a entirely different query for the value prompt. You could filter out the values you need.  ;)

Cheers
Charlie

[MFGF]

Yep. As Charlie suggests, just add the relevant filter to the query used to retrieve your prompt values.

Cheers!

MF.