Skip to Content
Former Member
Jul 01, 2011 at 04:34 AM

Capturing constant value data entered at query filter



I have two tables one is Customertab and other

is Customerver.

Customertab has two columns customerid and customer address

customerver has two columns customerid and customer version

For example in customer version table Customerid 100 has 2 versions 1 and 2

customerid 200 has 3 versions 1,2 and 3

customerid 300 has 4 versions 1,2,3 and 4

when ever iam developing the report in query panel filter the first

condition i select is customer id=100 and in the second filter condition i

am giving condition as verid= and select the version from LOVS. but if i

select the lovs iam seeing all versions.

My requirement is like as i have selected 100 in the first

filtercondition i have to see only 2 versions 1 and 2 in LOVS when

selecting the

2nd condition.

i dont want to use prompts. So can you please let me know is there any

possibility to capture the 100 some where and use the condition to restrict

the LOV's in the next filter condition