select specific value for filters

[xarapre7]

Hi experts!

I have a list of different filters/listboxes as follows:

Mgr1Open

Mgr2Open

Mgr3Open

Mgr1Resp

Mgr2Resp

Mgr3Resp

Mgr1Cls

Mgr2Cls

Mgr3Cls

And i have a MgrTypes field as 'O' for *Open, 'R' for *Resp and 'C' for *Cls

What should be the right expression for each Mgr filter above that when i select one, it will correspond to the right MgrType (eg. If i select Mgr1Resp, Mgr2Resp or Mgr3Resp only MgrType 'R' is selected)

Thanks in advance!

[fvelascog72]

Hi,

I think I don't understand your problem.

Try with my app.

Saludos.

[effinty2112]

Hi Preciosa,

In Settings \ Document Properties create a Field Event Trigger on selection of the field Mgr.

Good luck

Andrew

[its_anandrjs]

Do you have any type field.

[its_anandrjs]

It seems you have MgrTypes field if so then try this in Field Event trigger

MgrTypes

=Wildmatch(MgrTypes,'*R*')

OR

=Mixmatch(MgrTypes,'*R*')

Or

=Match(MgrTypes,'*R*')