How to pass the value of a field to another field?
Hello, my goal is to navigate selections by making sure that, if I select certain values from field1, they are reflected in the field2, erasing the selection from the field 1.
Let me explain with an example:
This is my table
Dim1
Dim2
Dim3
A
a
X
A
a
Y
A
a
Z
A
b
X
A
b
Y
A
b
Z
B
c
X
B
c
Y
B
c
Z
B
d
X
B
d
Y
B
d
Z
C
e
X
C
e
Y
C
e
Z
C
f
X
C
f
Y
C
f
Z
Now, I select value B from Dim1
Dim1
Dim2
Dim3
B
c
X
B
c
Y
B
c
Z
B
d
X
B
d
Y
B
d
Z
Now I want that Dim2 is filtered by the value I selected in Dim1, in this way:
Dim1
Dim2
Dim3
A
b
X
A
b
Y
A
b
Z
Up to here it works using a button and a variable.
I created a variable: variabile1=GetFieldSelections( Dim1).
The button has three actions:
Select in field --> Dim2=variabile1
Clear field --> Dim1
Clear field --> Dim2
You can see my example attached.
1. Is there a way to do this without a button?
2. If I select multiple value from Dim1, my button doesn't work. Any idea?
