Hello,
I am mostly done with a simple inventory database I put together to make life easier at work. The structure and scope of the database is pretty simple; we sell gift collections, the gift collections have between 5-10 items in them. The database is designed to let us select a gift, it pulls a list of items in the gift and outputs that list in a stylized way that can be printed and sent with the gift. Simple and works fine.
What I'm trying to now do is create a "Pick list" generator where we can go to a form and input the number of each gift we are trying to fulfill (3 of gift A, 7 of gift B, etc) and out will pop an inventory list of what we need to fulfill the gifts (so 3 of each item from gift A, 7 of each item for gift B, etc).
I'm able to make it work for one gift at a time using a simple query with a calculated field and criteria expression but am having a lot of trouble conceptualizing where to start to get this to work with multiple gifts at the same time. Any push in the right direction would be greatly appreciated.
Thanks!