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

    Selective Field Values for Calculation



      Selective Field Values for Calculation


           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.