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
------------------------------