Is it possible to dynamically reference columns from multiple linked tables?

[Rickard_Abraham]

Welcome to my suggestion, you are lucky post number #10

New formulas for columns

Goal Dynamically select a column from a table Issue The current possible approach forces you to repeat yourself into a coupled mess: Select Options Formula List("Population", "Area", "Density", "GDP", "Elevation", "Temp") Dynamic Column Formula Switch( [Select], "Population", thisRow.Population, "Area", thisRow.Area, "Density", thisRow.Density, "GDP", thisRow.GDP, "Elevation", thisRow.Elevation, "Temp", thisRow.Temp ) If you want to add a column you need to modify informati…