Selections in two fields at time

[#1]

Hi, I have two fields in two tables that can have the same values. I want to select/deselect a value in one of the fields and have the same selection in the other field. For example:

Table1:

LOAD * inline [

     FIELD1, FIELD2

     A,1

     B,2

     C,3

];

Table2:

LOAD * inline [

     FIELD3, FIELD4

     A, asd

     B, fgh

     C, ijk

];

I want if I select in FIELD1 the value A, FIELD3 have the same selection. If I delete this selection, I want to delete in FIELD3 too. And the same if I select a value in FIELD3, I will have the same selection in FIELD1.

How can I get this?

Thanks.

[MarcoWedel]

Hi,

if for whatever reason you don't want to change your script/datamodel, then using field triggers and selection actions could help:

hope this helps

regards

Marco