how to do this

Hi,
i am not a database expert. here is my requirement. i appriciate if someone could help me.
i want to maintain the product input/delivery information in the database.
input information table is like
ProductID, LotID, Qty

delivery information table is like
OrderID,ProductID, LotID, Qty

this is not straight forward because,
when i get an order for 100 units.
this 100 unit could be collected from different lots and shipped to customer.
i need the delivery information form to take productID from me and list all the LotID & Qty from input table which match the given productID

Thanks in Advance,
Sasi

thanks in advance,
Sasi