Creating macro to set value of a field when another field is changed

[#1]

Hi,

i am operating with 6 tables in a qlikview document with all the tables having some common features.

For example, there is a field 'country' in each of the tables. and there are around 10 similar fields.

So when i select country in one table i want to select country in all other tables.

Putting this in trigger would means i have to do the same thing around 60 times.

So i want to create a macro with all this clubbed together.

How to create the macro, this is a sample i created which gives error.....

if ActiveDocument.Evaluate("GetSelectedCount(country)")>0 then

          ActiveDocument.Field("ss1_country").SetContent "Getfieldselections(country)",True

          end if

End Sub

Pls help me out.

[#2]

By default, if we select the any country in country field in one table it will reflect to other table.