5 Replies Latest reply on May 12, 2014 8:24 AM by philmodjunk

    exclude parent value from drop down

    Kaps_1

      Title

      exclude parent value from drop down

      Post

           Hello,

           I am trying to set up a special sort of conditional value list. I have a table called product ingredient list:-

           * egg yolk

           * yeast

           * wheat

           * sour dough

           * white bread

            

           I then have a table called products - one of the fields is called product. Lets say that the current value of the product field  is called "sour dough". Then in a portal on the product table, called ingredients I want a drop down to have all the values of the product ingredient except sour dough appear. Likewise, if the product field was "white bread" the drop down would include all values from product ingredient except "white bread".

           I have created a relationship between the two tables as per the screenshot below.  thanks Kaps

            

      bread_bread_v1.png