This routine searches file name Filename for the value in Data in any cross-referenced data.
Syntax
NC.LOOKUP (Filename, Data)
Variable
Description of how the variable is used
Ranges
Filename
The file name to be searched
Any valid file.
Data
The value to be searched for in the file Filename
Remarks
If the value is a whole cross-reference "key" and there is only one item cross-referenced, the item will be returned immediately in the variable Data.
If the value is a whole cross-reference "key" and contains multiple original items, these will be displayed in a list box for the operator to select from.
Otherwise the routine will search for a partial match. If there are matches the routine shows all corresponding items, in a list box for the operator to select from.
The default search parameters for the file will determine the list box coordinates and the data to be shown in the list box. The item chosen from the list will be returned in the variable Data.