>USE \data\reference\lookupbc IN 0 SHARED >PUBLIC ARRAY acareloc(1,2) >SELECT alltrim(desc), id FROM lookupbc WHERE code = 4 INTO ARRAY acareloc >SELECT lookupbc >USE >If you are pathed through \data\reference then i believe you don't have to pre open the table (though I suspect that its faster if you do).
use in lookupbcHTH