Hi All! I am trying to create a database in which our small business can keep track of our inventory at all times. One of the things that we do is create gift baskets, therefore we have large quantities of supplies with up to 5 different people taking from them.
Is there a good way to have the inventory and have a way that everyone can check out the items that they take and be able to keep track of this while always having a running total of how much stuff is actually in stock so we know when to reorder?
Also. Is there any way to have the "Gift Basket" as an item but when someone 'checks out' a gift basket it also takes one away from each item in the basket?
Thanks!