Design Question

[tcoyle777]

I am trying to figure out the best way to set up a reservation system for items in inventory. I have a table with the items in it and I have a table to reserve those items. I want to be able to just pull down from a list say 20 of the items and have them be assigned to a project for the days needed. On the inventory items it would then show its on reserve. Any insights.

 

[JeanW]

Take your reservation into the calculation of the quantity and show this as separate item in the inventory table.

 

[tcoyle777]

Thanks,

I figured it out. It made more sense once I got into it. I was trying to make things more difficult then they needed to be.