conditional selection in field

[Anonymous]

Hi guys,

I have a selection field that calld "DEPARTMENT_DESC"

I have another field called "TEAM_DESC"

Is it possible to show only connected teams when ccertain is selected?

I have tryed this formula with no luck....:
=IF(GetFieldSelections(DEPARTMENT_DESC)='inland', Only({<DEPARTMENT_DESC={'inland'}>} TEAM_DESC),Only(TEAM_DESC))

thanks!

[sunny_talwar]

May be this

Aggr(Only({1<DEPARTMENT_DESC = p(DEPARTMENT_DESC)>} TEAM_DESC), TEAM_DESC)

or this

Aggr(Only({1<DEPARTMENT_DESC = {'inland'}>} TEAM_DESC), TEAM_DESC)

or this

Aggr(If(GetFieldSelections(DEPARTMENT_DESC) = 'inland', Only({1<DEPARTMENT_DESC = {'inland'}>} TEAM_DESC), Only(TEAM_DESC)), TEAM_DESC)