5 Replies Latest reply on Jul 14, 2017 8:11 PM by philmodjunk

    Conditional formatting based on value of related row

    nonsequitur

      Hello,

       

      I have three tables, for simplicity we'll say the first is a list of fruits.

      Fruit

      1. Apple

      2. Orange

      3. Banana

       

      The second table is a list of fruit attributes

      Attributes

      1. size

      2. color

      3. Shape

       

      The third table is a join table linking the first and second tables. i.e. an apple would have three attributes

      Set Attributes

      1     1     medium   

      1     2     red

      1     3     Oval

       

      From the layout for the first table, how do I return the text contents of the shape attribute for Apple.  I.e. How do I grab "Oval" out of the join table with the foreign key value of "3"

       

      I know this is probably really easy, but my brain is not working and I figure rather than spend the next three hours looking I might as well just ask.