Multiple columns in Cascading LOV (no concatenating)

[mhmohammed]

All,

I've a requirement to display Multiple columns in Cascading LOVs.  Is it Possible?  The Hierarchy is as follows:

Sub Division Code | Sub Division Name

                         Department Code | Department Name

                                                  Sales Rep Code | Sales Rep Name

Thanks,

M Mohammed

[Former Member]

I am not 100% sure If I understood what you are looking for.

However based on your post you can create a derived column in universe for each of Hierarchy level using concatenation of your code and name in the desired format then define the cascading LOV on these derived columns. How you create the cascading LOV is different in BO 3.1 and 4.0.  Just search in SCN  and you will get how to do it in your BO version..

Hope this helps!!

[mhmohammed]

I don't want to Concatenate the Code & Name as we lose the capability of sorting on the 2nd column.