6 Replies Latest reply: Feb 16, 2015 1:22 AM by Jonathan Dienst RSS

    Have a field inherit value if data in a different field matches

    Vince Agresto

      Evening folks,

       

      I am looking for some help with what I fear may be simple.

       

      There are two fields in a data-set that I want to relate.

       

      Every row of data has Field 1 complete - Field 1 is ProjectType

       

      Field 2 is a number value for classification that will be filled out for only one of the rows of data.

       

      So the data looks like this:

       

      Table : PROJECTFILES

      Project TypeClassifier
      Type A

      Type A

      Type A
      Type A
      Type A12345

      Type A

      Type A
      Type B
      Type B67890
      Type B
      Type B

       

      I want to the single classifier to inherit for each matching type - i.e. anything Type A should have the classifier of 12345

       

      Thank you for any help you can offer

       

      -Vince