When you create a reference between tables, a reverse reference list will be created in the parent in the form of a “Related Whatever” virtual column that’s a list.
Sometimes though, you only wish to create a reference so you can use the de-reference system - or to otherwise hold that information as a variable. (Such as who the “lead” for a project is)
But whenever you create a reference, the reverse reference list is automatically created. In fact, if you make any significant modifications to the formula, this will cause ANOTHER system generated reverse reference list to appear.
By default, the system expects - and enforces - there to be a single “Related Whatever” virtual column with a base formula of
The current “hack” to remove these extra list column is the change the formula to “List(”")"
- which long ago was implemented as a hack to get around this very same issue.
This works, but it leaves you a bunch of “extra” columns that you just have to remember aren’t the actual “related whatever” columns.
How about the ability to indicate, on the reference column’s type qualifier level, whether or not this reference should produce that list or not.
As always, thanks for considering! (^_^)