I need to look up some data from another file in sesame based on two elements in that file. 

For example, from one file I'll have a lot number that I want to look up in another file as LOTNO.  However, there may be duplicate LOTNO records for different material numbers (MATNO).  So I need to be able to find the record that matches LOTNO and MATNO, then select the data I need.

Is there a way to do this?  Please advise ASAP as this is a hot project for my company.

Thanks!

Paul