Three Level Dynamic Cascading prompts

[bunnycat]

I would like to know if I can do the following:

I use Crystal XI / ORACLE

I would like to use a three level dynamic cascading prompt. When the user selects the top level organization (level 1), I would like the lower level (2 and 3) pick lists to populate with the divisions and the unit codes associated with the selected organization. There are some customers who know the unit codes but not the division name. Vice versa, some know the division name but not the unit codes. Is there a way to have both pick lists (2 and 3) based on level 1 pick list?

For example:
(Level 1) (Level 2) (Level 3)
Top Level org Divisions Unit Codes
Air Force Div 63 A0386
Air Force Div 65 A0391
Air Force Div 66 A4444


When the user selects Air Force
The Division Pick List will populate with
Div 63
Div 65
Div 66

And the Unit Code Pick List will populate with
A0386
A0391
A4444

Is this possible?

Thank you in advance.