Zoho Creator - Production Management

Hi,

I am trying to use Zoho Creator for Production Management for a well known Material Processing Plant. In that plant, production moves in Phases and the materials are processed in Batches.

For example,

Phase - 1: Material is Issued for Production

Here, I would like the Material Issuer to Record the Lot No and the Quantity Issued

Phase - 2: Prcessing

Here, I would like the Processing Manager to receive the Lot and Process it, and Record its completion

Phase - 3: Finishing

Here, the Final Aesthetic Finishing operation is done. Here the Finishing Guy should receive the material that is processed to be Finished.

The problem comes when trying to use Look Up function, when the Form for Finishing opens all the Lots issued comes in it. I only want the Lots which are "Processed" to appear in the List, and not the Entire Issued Lot.

Hope I am clear.

Your help would be well appreciated.