Hi Vicky,
You say you created a hierarchy, but I do not think you need one for a cascading LOV. I only use hierarchies for drilling purposes. I think just creating a cascading LOV in the universe would be enough. Should not cause any problems either, but you never know.
Although I never ran into issues 1 and 3, here are some suggestions:
-
You could try converting the two numeric datatypes to character ones by using a convert function within the object. Then sorting them might be a bit of a problem, but you could try it just to see if the problem is indeed being caused by the different data types.
-
I solved this by creating duplicate objects in the universe, used these in this particular LOV and nowhere else.
-
Sorry but I am not sure how the select ALL works with cascading lov’s. Have found some posts regaring the ALL option though:
FAQ: Designer (first two issues)
Can we add All/NA to the list of Values
Regards, Hans
hans909 
(BOB member since 2006-05-09)