Accesing fields from two resident tables

[#1]

HI guys,

I have this script.

[Table1]:

Load

Amount

Resident A;

[Table2]

Load *,

If (qty < 0, Table1.Amount * -1, Table1.Amount)

it complains the Table1.Amount as field not found.

I wanted to know if it is even possible to access fields from other resident table the way i am trying to do.

Regards,

Saurabh

[Clever_Anjos]

Is there any keys between those tables?

Check your manual for LOOKUP() function, maybe it can help you

[jagan]

HI,

Is there any primary key between the two tables, if yes then join the two tables and then perform the calculation.

Regards,

Jagan.