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?