ms access how to distribute Quantity based on record needs

[msaccess4me]

for example: there total of 100 parts in stock
and there 4 orders need this part

order 1 need 50 due on 5/26/2019
order 2 need 30 due on 6/1/2019
order 3 need 40 due on 6/5/2019
order 4 need 60 due on 6/10/2019

what Can I do so I can distribute the total amount in to each order as need, so I can see which order is going to be short and when going to be short.
like below

order 1 need 50 due on 5/26/2019, qty in 50, qty short 0
order 2 need 30 due on 6/1/2019, qty in 30, qty short 0
order 3 need 40 due on 6/5/2019, qty in 20, qty short 20
order 4 need 60 due on 6/10/2019, qty in 0, qty short 60

Thank you in advance

[NeoPa]

Well, the first thing you need to understand is that you can only create a system to reflect your requirements when you have your requirements fully defined.

Before you consider how to design this you need to decide how you want items to be allocated. Do they get allocated once the order is entered onto the system? Do they get allocated only when they become due?

Each of these two (non-exhaustive) example approaches has pros and cons. Your job is to consider those and decide how you want to proceed. When you get to that stage it may be that you need help to make it happen, but I suspect once you've done that necessary work you'll have a much better idea what you're dealing with and probably have enough understanding to implement it without recourse to our assistance.

Obviously, once you get to the stage where it's appropriate to ask for help then feel free to come back with a request if you need.