AnsweredAssumed Answered

Changing column names in a cross reference table

Question asked by cbhj500903 on Mar 15, 2018
Latest reply on Apr 18, 2018 by GuinScholl3001

It seems to me that when referencing a cross reference table column (say column #2) for output in a lookup, the lookup still works after changing the name of referenced column (#2). Now if I insert a new column pushing back column #2 to column #3 the lookup no resolves to the value listed in the new column #2.

This behavior suggests that cross reference lookups reference table columns by their order number in the table.

And what happens if new columns are inserted while retaining the column names. Will the lookup still reference the column by name or by column number.


I was unable to find any information on this, so It'd be good to get an exact explanation on how this is supposed to work.