Get associated value from a Field

[microwin88x]

Hello!

I have two fields, Zone and Office.

1 Zone -> N Offices

And every Office is associated to one Zone

If I select a particular Office, I want to know if there's any function to get the associated Zone to that selected Office.

Is there any way to do that?

Thank you!!!

[MK_QSL]

Create a text box and type below...

=CONCAT(DISTINCT ZONE,', ')

[#3]

Only(ZONE)

will only work when you select an office

there is a few ways to get that value, I believe the above is best

else Maxstring(ZONE)

or FieldValue('ZONE',1)

or CONCAT(DISTINCT ZONE,', ') as per Manish