De-refs inside a lookup don’t work.
LOOKUP([Column2].[Column5], Table1, Column1, Column3)
I’m looking up a record from table 1, while editing a different record on table 1 - basically I’m trying to look up a value from a previous record.
But the lookup isn’t accepting the deref.
The de-ref works, if it’s by it’self.
But if you try and use it in the lookup, it doesn’t work.
I didn’t save any version with this setup, this is a bug I’m familiar with and the work around is to import the de-ref into a column and then use that new column in the lookup.
But this means I have to have an additional column in my table.
Could the de-ref work in the lookup?