Hello, i'm a filemaker newbie. I'm building a purchase order system for my company and the standard Purchase Order template does not fit my needs. I've got most of the fields and layout figured out but am stumped on certain calculations. I have attached pic of the P.O. layout for your reference. Here goes:

I am building a P.O. for clothing so when we do our orders there are always multiple colors with different qtys. I have given each category 18 repeating values (so each style has 6 repeating values for to cover all the information) However my problem is that when i want to subtotal each style (6 repeating values) I don't know how to specify that the sum be of just the 6 repeating values. Meaning i need the sum of Total Quantity 1-6, Total Quantity 7-12, & Total Qty 13-18. Once I have this individual style Subtotals I can correctly calculate the subtotal Price FOB, CND, & Retail.

For Style #, Category, Description, FOB Price, CND, & Retail all info in the repeating fields stay the same. I just don't want to show the same information for asethetic reasons and to avoid confusion and mistakes. Is there a way I can add the information into the remaining repetitions (1-6) without having to view them. This way if I need to go back and look at individual info everything will be pulled up correctly.

Any help is greatly appreciated

thanks

Amit

Here is a link to the actual database if you need it. Its database is pretty much empty so the file is only 1mb

Database Link

thanks

Amit

Repeating fields are, in essence, arrays. We reference an element of a repeating field by [x]. So, for Total Quantity of 1 to 6 you would have tot_quant[1] + tot_quant[2] + etc.