Get field value

[eliran]

Hi all,

A quick question for you, I have a table of countries and one of the attributes is Region Code.

When the user selects a specific country, I would like to return the text from the region table (description).

I didn't bump in a function that receiving field value, a function like this would help in this case.

I'll appreciate any help.

Regards,

Eliran

[swuehl]

Hi,

is it not possible to link the two tables with common field name (maybe Region Code)?

Like

Table Country:

Country, RegionCode

USA, 1

Table Region:

RegionCode, Desc

1, North America

[lironbaram · Accepted solution]

hei

assuming there is only one value after you selected the country

you can write this expression in the text box

=only(region Description) that way when you wo'nt select a country it won't show anything

if there is more than one value you can use

=concat(region Description,',') that way it will show all the possible values in the field sperated by comma

hop its help you

[eliran]

Hi Liron,

I knew it was something easy..

Only was what I was looking for.

swuehl, they are connected of course, I just forgot how to take out the string according to selection.

Thanks.

Thanks!

Eliran.