I have a field which needs to get a random value in context of another random value.
Let’s say I have a random person row
Person has a field with a favorite specific food.
I want to generate a random value for a food type and lookup a specific food.
So the first lookup from a random list is type of food: eg. pizza, and the second loopup is the detailed food, e.g. margarita.
How do I achieve this?