1 Reply Latest reply on Apr 24, 2013 10:43 AM by philmodjunk

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

    DonnaDonoho

      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

        • 1. Re: Can someone give me a little push I am trying to find a way to
          philmodjunk

               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.