A one row filtered portal that filters for the desired item.
Why have three tables rather than three fields in one table?
First field: Fruit
Second field: Attribute
Third field: Set attribute
You can create value lists for eat field and even make the popups relational.
Now your conditional is much easier to work with.
Then there is that issue of not getting values from the third table in the relationship if there is not a common relating field.
Because this is a vast oversimplification of what I'm doing.
Say I have a portal with a single row filtered. How would I grab the contents of the column I want from inside a conditional format?
Make it a filter for "3", the ID for "shape" on a portal to the join table.
Also, it can be very useful to set up your layout based on the join table rather than one of the other two table occurrences and then include the fields you need from all three tables on this layout.
And when you "vastly oversimplify" your example, you run the risk of getting suggestions that won't work for the actual situation. Better to provide more info on the actual set up instead of such a simplified and abstract example.