Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is there any keys between those tables?
Check your manual for LOOKUP() function, maybe it can help you
HI,
Is there any primary key between the two tables, if yes then join the two tables and then perform the calculation.
Regards,
Jagan.