Variables and fields

[Greg Hains]

Hi.

I have a database with several tables that are linked, and need to display values of some fields from these various tables onto a particular layout.

If the layout I am on is the same as the one that contains the field value I wish to display, then the value is correct, yet making reference to fields on layouts whose table is one other than the field being displayed then I get nothing or zero.

I was thinking of setting a global variable that could pick up the value of the other table's field but dont know if it's possible to display a global variable directly onto a layout.

Anybody got an idea how I could do this?

Thanks in advance.

Greg

[bcooney]

It will be faster to see what's you're doing incorrectly if you post your file (save as clone and zip).

You are probably selecting a field in another table and not specifying the correct context.