### Title

Can someone give me a little push I am trying to find a way to

### Post

Calulate a total weight field and also have a weight feild For Example:

My weight is 10 Lbs on one item but I am ordering and shipping 15 items I would like to have a total feild to caulate all the weights for a complete weight total.....Thank you if you can help me

A typical order form uses one table for the "order" records and a related "lineItems" table to list the items ordered for each order. The typical layout is then based on Order with a portal to LineItems.

Is that what you have?

If so, you can use Sum ( LineItems::cItemWeight ), defined in Order to compute the total weight of your orders.

cItemWeight would be a calculation field defined as: quantity * UnitWeight.

UnitWeight, like a UnitPrice, would be looked up from a related table of products.