3 Replies Latest reply on Jan 28, 2013 1:28 PM by philmodjunk

    Please help a newbie with self-join relationship / value lists

    vincel

      Title

      Please help a newbie with self-join relationship / value lists

      Post

           I've been using Bento but looking for something that will work better.  I think what I want to do is easily accomplished but i'm coming up short.  I have a database where I've setup 1 table at this point.   When I select a value for "Lamp Type", I want the "Lamp Size" values to only show either the "T8 lamp sizes" or "T12 lamp sizes" value options based on what was selected.  

           To explain another way

           So my values in "Lamp Type" are T8 or T12.   If I select T8 then I want just the value list from "T8 lamp sizes" to show up under the "Lamp Size" field and if I select T12 then just the value list from the "T12 lamp sizes" to show up under "Lamp Size"

           Hope this makes sense

            

      Screen_Shot_2013-01-28_at_3.05.03_PM.png