two columns and trigger

[saumyashah90]

i have two columns

ColA and ColB

223          225

224          223

225          224

these have same values.

So o have made something like...when a person click on 223 in ColA, automatically 223 will get selected in ColB

using a variable.

and same if a person select on 224 on ColB  automatically 224 from colA gets selected.

now i want to deselect both if any one of it gets deselected

for example if i deselect 225 in ColB , selection should get removed from ColA also

Also i should be able to click on multiple fields together

[sunny_talwar]

I am not really sure how your data is structured. Would you be able to share a sample application?

[avinashelite]

Try like this :

you need to make use of Onselect and Onchange triggers on the two fields and based on the selection i.e 0 or more you need to set the corresponding conditional trigger

[MayilVahanan]

HI

May be try like attachment

[saumyashah90]

Hi Sunny,

its simple.

Two columns not linked with each other.

But values inside are same.

Just need selection and deselection of both column values to get effected at the same time

[saumyashah90]

Hi Mayil,

I appreciate your efforts,

but i cannot make any changes in script.Just think i dont have permissions.

I just need to work on UI

LOAD COLB Resident T1;

DROP Field COLB From T1;

This i know its correct but i cannot use.

I only have to work on front end

[himanshi]

hi,

can you explain how did you do that.

[MayilVahanan]

Hi

If you have only two fields, then try like attachment.

Document properties -> Tables -> Check the loosely coupled tables.

It breaks the link between the fields in that table. so u can achieve it..

But its strongly not recommended.

[ahbzshk07]

Hello Saumya!

I believe setting triggers itself will solve your issue. You wont have to do anything in script, unless those two fields have same values.

Just in addition to Mayil's solution, use this:

For COLA trigger: (onSelect) Select in field: COLB ; Search string ='('&GetFieldSelections(COLA,'|')&')'

For COLB trigger: (onSelect) Select in field: COLA ; Search string ='('&GetFieldSelections(COLB,'|')&')'

These changes will work for multiple selections as well...

Thanks & Regards,

Shabaz Shaikh

[ahbzshk07]

*unless those two fields have different values...

Sorry for my mistake...