This is our exact issue which we face.
We have three different querries.
Q1 , Q2 , Q3.
In Q1 where clause we prompt the user to give the State value.
In Q2 where clause we prompt the user to give the County Value.
In Q3 where clause we prompt the user to give the city value.
when we use cascading prompt it prompt in Q1 It prompts the user to enter the state value(here state is the parent top hierarchy)
For Q2 it asks the user to enter both State value as well as county value.(what happens here is it asks the user to enter the state value and displays the Counties of that particular state)
County is the next level after state( state -> county)
For Q3 again it asks the user to enter the state value , county value and city value. (what happens here is since City is created with a cascading prompt it prompts the user again to enter from the top hierarchy)
State->County->City
But what the client expects is when State name is entered in Q1 it must display the values of counties of that particular state in Q2 and when user enters the county value it must display the Cities of that county in Q3
Is this Possible!!!
selva_bo (BOB member since 2006-10-30)
(BOB member since 2005-07-18)