I have the db Orders which relates to LineItems via OrderID. Each
LineItem falls into one of 7 ProductTypes. The sales team enters
LineItems through a portal. I want to have a subtotal for each
ProductType on the Orders layout and on the invoice layouts (which are
LineItems layouts).

What I came up with was all based in LineItems. 7 calc fields and 7
summary fields per record (one of each for each ProductType). Only one
calc field has a non-zero value. This is in addition to the Line Item
info and the Grand Total summarys. It seems like a lot of calc and
summarys to me and it takes a looong time to perform certain fucntions.

Any design tips?

Thanks,

G