1 Reply Latest reply on Apr 14, 2013 8:49 PM by schamblee

    Price List Problems

    TracyBogans

      Title

      Price List Problems

      Post

      I want to be able to select the Product Name& Cost  and have it  total at the bottom of the layout based on the items I have selected/checked in the Value List 

      Table1 -  Product List - FieldName:ProductCode &  FieldName:ProductName.

      Table 2 - Product Cost -FieldName:ProductName & FieldName:ProductCost

      Table 3 - Client Order -FieldName:ClientName & FieldName:ProductCode 

           within this layout  I have a  Value List with the Product Name & Cost for all prouducts that fall within the Product Code. Value list is pulled from the Table 2 (Use values from Table2)

           I have created relationships between the tables  

             
      •           Table1/Table 2 is ProductName
      •      
      •           Table3/Table 1 is ProductCode

            

      I want to be able to select the Product Name& Cost  and have it  total at the bottom of the layout based on the items I have selected/checked in the Value List