AnsweredAssumed Answered

beginning user needs help with inventory question

Question asked by b34n3 on Jun 9, 2010
Latest reply on Jun 11, 2010 by LaRetta_1

Title

beginning user needs help with inventory question

Post

I am creating an inventory database in FM pro 10 on a Mac. I need the inventory to track various types of equipment. Specifically i need it to update total quantites of each type of equipment both when equipment is out on loanand also when it is returned. Basically a function that would subtract quantities when an invoice is created and then add the quantities back in when the items are returned. 

I have tables for equipment, inventory, invoices and line items.It seems like this should be relatively simple but i can't figure it out. Any help would  be greatly appreciated ! 

THanks!

Outcomes