KEYLOOKUP()
From Lianjapedia
Contents
Purpose
Function to perform a cross-table lookup
Syntax
KEYLOOKUP(<workarea | alias | table>, <"tagname">, <keyExpr>, <valueExpr>)
See Also
LOOKUP(), RLOOKUP(), SEEK(), SET RELATION
Description
The KEYLOOKUP() function looks up the specified index <keyExpr> in the index <tagname> of the specified <workarea | alias | table>. The KEYLOOKUP() function then evaluates the expression <valueExpr>, and returns the value of the <valueExpr> if the <key expression> is found. The KEYLOOKUP() function returns a null string if the <key expression> is not found.
The current record position in the specified <workarea | alias | table> cursor is not moved so this function can also safely be used in SQL queries.
If the specified