AnsweredAssumed Answered

Price List Problems

Question asked by TracyBogans on Apr 14, 2013
Latest reply on Apr 14, 2013 by schamblee

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 

      

Outcomes