AnsweredAssumed Answered

Reverse conditional value list?

Question asked by M.Z. on Jul 22, 2013
Latest reply on Jul 23, 2013 by M.Z.


Reverse conditional value list?


     I'm a database design newbie and I wonder if someone could tell me how more knowledgeable people would refer to the type of structure I want to make so that I can figure out how to make it. 

     Basically, I want to do what's described in the "Creating Conditional Value Lists" support page, except in reverse. I want the user to be able to input "Tomato" and have the database fill in the fact that this is "lunch" and "soup". The relationships are tree-like and the names are unique; "tomato" could not be anything but "soup" and "soup" could not be anything but "lunch". 

     So, what do you call this?