Im using different tables. (table 1 - table2)
with different fields inside (table1::field1, etc..)
Now, when Im in format of table1 and I drag and drop a field from table2
the tool asks me which field from which table and correctly drop table2::field1 on the screen
but its has an orange pin on it and that field doesnt work.
The first question is: I cant just drop field_x from table2 on the format of table1 to see it?
I've tried to build a relationship. So I made a field_x on table 1 and related to field_x of table 2 (=). The pin is again orange and the filed is not displaying anyway