Drill Down

[#1]

I have  a Drilldown group called "GeoLevel" with fields Nation, REGION_ID, DISTRICT_ID and TERRITORY. I have another list box with field [Geography Level] that has Nation, Region, District and Territory in it. I want to control the selection in such a way that if i drill down to REGION_ID in the drilldown group the [Geography Level] list box should be at Nation level. similarly if i go to TERRITORY in drill down group, [Geography Level] should be at District level again if i come up to DISTRICT_ID in the drill down the [Geography Level] filter should be at Region Level.

For that i created a variable called vGeoLevel with its value as

GetCurrentField([GeoLevel])

Now in triggers i have provided action to the variable OnInput "Select in Field"

Field= [Geography level]

Search String=

if(GetCurrentField([GeoLevel])='REGION_ID','Nation',   
if(GetCurrentField([GeoLevel])='DISTRICT_ID','Region',    
if(GetCurrentField([GeoLevel])='TERRITORY','District')))

On change also i have given the same action. Ideally it should work because i have done the same thing once with cyclic group. But i dont know why it is not working

[v_iyyappan]

Hi,

     Cau u attach a sample application ?

regards,

Iyyappan

[sivarajs]

use getselectedcount instead of getcurrentfield

[#4]

getselectedcount does not work.

[sivarajs]

Check the attached sample