AnsweredAssumed Answered

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

Question asked by vincel on Jan 28, 2013
Latest reply on Jan 28, 2013 by philmodjunk

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

Outcomes