Field Triggers

[#1]

Hi,

I have two fields connect by triggers OnSelect and OnChange:

Action: "Select Field" - DIM_A

Search String: ='("'&concat(DISTINCT DIM_B, '"|"')&'")'

I works fine except when there is no field selection on DIM_A, all DIM_B options became selected, and I don´t want that to happen..

Thanks is advance,

Francisco

[#2 · Accepted solution]

I found the solution:

=if(GetSelectedCount(DIM_A)<>0,'("'&concat(DISTINCT DIM_B, '"|"')&'")')

Thanks any way...

[MK_QSL]

Try

='('&concat(DISTINCT DIM_B, '|')&')'