Hi @Joseph_James - I would do something like this:
“Assigned to Employee” is a link field to the second table:
You can then use a “count” type field to count the number of shirts assigned, then take this from the original quantity ordered to get the the current inventory.
If this answers your question, please consider marking this as the "solution". If not, please post again for more help. Thanks!