Hi @ABp,
I took some time to figure out what you wish.
Basically, (I think) you need a polymorphic column that could act like a Lookup (see Edit below).
Disclaimer:
I would not suggest it as a solution, but let’s see if it’s a nice starting point to play around with.
Why?
Well, “dynamic lookup” is strongly coupled with tables structures.
I used a common Status (in fact, not strictly necessary) in order to mitigate it a bit.
Essentially, you’re moving the “multiple columns” in the fallback chain logic. It’s more hidden, but still…
Please, have a look at the modified example and tell me if it’s closer:
Let me know if this meets your needs.
Cheers!
Edit:
If this (Table Extensions) would be taken into consideration, this solution would become straightforward by design… 