Hi,

lookup_local funtion retrieves the first matching record from a partitioned multifile,which is partitioned on a particular key.

consider a lookup file "emp_detail" which is having the fields emp_id,emp_name,dept and is partitioned on emp_id.

use,

lookup_local("emp_detail","456A"),then u will get matching record for "456A" . where "456A" is the one of the emp_id.

hope this helps u

mukund