4 Replies Latest reply: Nov 7, 2014 3:31 AM by Ksenia Babikhina RSS

    Mathc fieldvalue from two other tables

      Hi all!

      Could you help me with this issue:

      I have two tables:

       

      Color

      Green

      Red

      Orange

      Yellow

      Other

       

       

      Item

      Sweater for girls Green

      dress  Red

      Bag Orange apple

      Yellow coat

      Blue jeans

       

      The result I'm looking for after comparing these tables would then look like this:

      Field1

      Field2

      Sweater Green for girls

      Green

      dress  Red

      Red

      Yellow coat

      Yellow

      Bag Orange apple

      Orange

      Blue jeans

      Other

       

      Which is the best way to do it?