validiation in Text prompt

[Srik]

Hello everyone,

I have a Text prompt ( optinal ) where user enters a value(alpha-numeric) if number is available in tableÃ,  it shows up with values in the report.

But the requirement is that when user enters value in text prompt.

1. If the value enter is not in database table it should display or pop upÃ,  as "Invalid " in the report page.


Please help me if some one came across this kind of validation.


Thanks
kanth

[JGirl]

Does the prompt have to be a text prompt?

Maybe try using a 'select and search' prompt, with the prompt being populated from a database query so that only the records in the database are available for selection?

J

[Srik]

I can try with your option but what happens when user enters invalid number ?
Then it should display invalid number in the report.

[joshua]

If you populate the prompt from a db query the prompt only shows valid numbers. So the user will not be able to select any invalid numbers. Problem solved ;)