Hello,
I am trying to build an inventory database and I'm running into an issue that I'm not sure how to approach. We have different locations and each location is allowed a certian amount of each item. In my example table below, Item A and Item B have fixed allowances of 10 and 15 respectively. The issue I'm having is Item C, D, and E have an allowance of 30 but it can be any combination of those items to make 30. How do I do this? Thank you for your time.
tblINVENTORY
ITEM ALLOWANCE
ITEM A 10
ITEM B 15
ITEM C
ITEM D
ITEM E