LOOKUP( EmpFcur.Both, M.EmpNo, EmpFcur.EmpNo, 'EMP' )>It looks up a value in the alias EmpFcur. It appears to work, even if EmpFcur is not the currently selected alias. I assume it is an undocumented, and very handy, feature.
CREATE CURSOR master ( aa i DEFAULT RECCOUNT()) APPEND BLANK APPEND BLANK CREATE CURSOR child ( aa i,bb i) INSERT INTO child values (0,-1) INSERT INTO child VALUES (1,-2) INDEX ON aa TAG taa SET RELATION TO aa INTO child IN master ? LOOKUP(child.bb,1,master.aa) ? LOOKUP(child.bb,0,master.aa) CLOSE TABLES ALL