Prompt with ID and Description from LOV ..

[Former Member]

Hello,

is it possible to base the filter of a Prompt on for Exp. Product_ID but to show in the prompt both Product_ID and Product_name. Both values should be LOV-Values. Reason is that we have duplicate Product names wihich filter many IDs if we base the filter on the Name ...

Message 'Please select a Product'

display like '12012 - Productname X'

multi Vallue

Thanks ..

[Former Member]

Hi,

Create a Cascading prompt on Product name like below.

1. Create two objects called Product Id and Product name and in Onject properties check Export with Universe for LOV's option.

2. Write a prompt on Product name like below in universe

Select Product name form ********* where Product Id = @Prompt("product Id")

3. Define Prompt for Product name in Universe/Report level as required.

Cheers,

Suresh A.