Hi everybody,

Ok, this would be a most complicated question for the day (or beginning of the day).

Here is a method I'm duplicating:

/// <summary>
        /// Get Order Subtotal
        ///     returns the subtotal of all items in a given order.
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public decimal GetOrderSubTotal(OrderDetailsDS.OrderDetailsDataTable dt)
        {
            decimal subtotal = 0.00M;
            foreach (OrderDetailsDS.OrderDetailsRow  dr in dt.Rows)
            {
                if (!dr.RowState.Equals(DataRowState.Deleted) || !dr.RowState.Equals(DataRowState.Detached))
                {
                    subtotal += (dr.Qty  * (decimal)dr.); // not yet complete
                }
            }

            return subtotal;
        }

However, in my case the Price is in the Inventory table and I don't have it in OrderDetails. So, what should be my approach to take here?

1. Add the Price field to the table OrderDetails?

2. Somehow add this field from the Inventory related table into TA?

3. On each record attempt to retrieve Price from another table?

Thanks in advance.