2 Replies Latest reply on Oct 28, 2013 8:08 AM by philmodjunk

    Selective Field Values for Calculation

    KeithWallace

      Title

      Selective Field Values for Calculation

      Post

           Hi everyone, noob here.  
            
           I'm trying to use the forum to get most of the answers but I have one I'm a little stumped on.  
            
           I have 2 tables.  
            
           The first is for product data (A) which holds the part details along with it's weight.  
            
           THe second table (B) is for a production record, at the end of the record I want to calculate the total amount of material used.  I want to do this by using the total cycle amount in table B with the part weight in table A.
            
           The problem I have is I need to make it use the correct field value in A depending on the part I choose for production in table B. (All the details in table B are derived from the Table A part details)
            
           That's where I get unstuck as Table B needs to know what part I'm using so it can calculate the correct weight.