devide lot by qty value

[aqeelnokia99]

hello All . i have a question i have a table with name po and qty and lot
i need result lot how like i post image in image i give fist lot until his lot vale equal or grater then his total then pick next lot until his balance equal and grater then to qty .

https://cdn1.imggmi.com/uploads/2019/3/16/ea543cacd2c380192d211c5867d313e8-full.png

 

[oldbrewer]

make up a demo sheet and copy it here in the reply box, and try to explain more clearly please.

 

[aqeelnokia99]

i was upload image lol dont know whre he gone ok i update data in new post make again