Use case or problem
I'm trying to generalize a table for all my notes. I have a property "area" that helps me sort my notes ("health", "finance", etc). and I have a "topic" property. If I select area=health, I don't want to see 401K in my topic dropdown. Or another example, if I have property animal and select cat, I don't want to see rottweiler in my breed property dropdown.
Proposed solution
There should be a way to use a conditional operator or case statement to point to which property list gets selected for reading and writing which is dependent on another property selection
Current workaround (optional)
The only workaround I can think of creates extra properties so that I would have to use different tables. Instead of one property "breeds", there's be "cat-breeds", "dog-breeds", "bird-breeds, "cow-breeds", etc., and to reduce clutter, this would require using different tables for each instead of just one highly filtered table, which requires more jumping around.