Substitute a null field with another field from a different table

[#1]

Hi,

I would like to know how can I substitute a field in a table with other field existent in other table if both tables are linked to each other.

For example, what I want to do is if (isnull(TableA.x), TableB.y, TableA.x).

If filed x from table A is null I want to substitute that field with field y from table B. Table A and B are linked through a common field.

Thanks in advance!

Mariana

[#2]

Hi,

You can use ApplyMap() function.

Check the attached application.

Or you can join both the table and get your desired result.

-Peterson

[#3]

Thank you very much.

It helped!

Regards,

Mariana