Save Table Aliases and use in formulas?
Hi all,
Can I save the table alias in a field and then use that value in a formula?
Example is a field in the table that identifies another table where I will lookup a value.
This works, the table alias is _DBID_UTILITY_MATRIX
GetRecords("{query}", [_DBID_UTILITY_MATRIX])
This doesnt work
GetRecords("{query}", [Calc Table Name])
Where [Calc Table Name] is a text field with value = [_DBID_UTILITY_MATRIX]
Either [_DBID_UTILITY_MATRIX] or "_DBID_UTILITY_MATRIX" Any ideas?
My fallback is to create a series of case statements with the alias hardcoded like this
Case([Calc Table Name],"table 1",GetRecords("{query}", [_table_1],
"table 2",GetRecords("{query}", [_table_2],
"table 2",GetRecords("{query}", [_table_2])
Gerry
------------------------------
Gerry Munroe
------------------------------