okay i have downloaded the business template for filemaker pro 8, and have been racking my head all day. I have been able to setup an inventory system for the apparel company i work for complete with the size quanities. My only problem is i can't get the sales order form to subtract the indivdual counts from each different size, it will only deduct the totat quanity.

So how can i take the fields i have in my sales order form... which has shirt style, and sizes m-3xl and get those decuted from my inventory count. I have played around with the global function but cant seem to get it right?


thanks