I have a single table with these fields:
ItemNo.,Description,Brand,Quantity,DocumentNumber,Expiry date

the Procedures is in this way for user:
1- user will write Document Number To Capture data by Remote view From Another system,
After that he will write an Expir date for each Item No, Then he will save it to Another table Called Prodexp.
Note: This Procedure is like a Person who writes a bill

2- In Another Form the user will write ItemNo., In grid Will show him all Description,Brand,Quantity and Expir Date for same ItemNo. with deferent Document Number, This Form made it to let user takes from quantity but system should let him takes from nearest expire date until user makes the quantity equal 0, when it become 0 user can takes quantity from next nearest expire date, and so on