beginning user needs help with inventory question
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 !