ContributionsMost RecentMost LikesSolutionsRe: Save Table Aliases and use in formulas? The table ID works great - Ill run with that. Ive always used aliases before. Thanks so much! Gerry ------------------------------ Gerry Munroe ------------------------------ Re: Save Table Aliases and use in formulas? Thank you for that. It works as you said, but not when entered as a text field which I had. Still dont think I can save the table name in a field, and then ref that in a formula text field to get it into the Getrecords statement. its not recognized. To be clear - try putting [_DBID_DEVTEST] in a user entry text field, then see if you can use that somehow. I cant get it to be recognized! Thanks so much for responding. Gerry ------------------------------ Gerry Munroe ------------------------------ 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 ------------------------------ Re: Combined Text Summary Field (Order and Clean) Thank you so much, this is genius! ------------------------------ Gerry Munroe ------------------------------ Re: How to do many many calculations Each project has unique values in the variable. ------------------------------ Gerry Munroe ------------------------------ How to do many many calculations Hi we are converting an excel app. We will have a Projects table with 5 projects. There will be about 10 tables that have lots of calculations. There are about 300 variables that the user enters, and are used variously throughout the calculations. Im wondering how to organize the variables and calculations. I could add all variables as fields in the project table and link the tables or use query functions to use them in calcs. OR I could have a variables table, with a record for variable name and value, but not sure this works for the calculation field (diff formula for each record?). Any ideas how to handle this? ------------------------------ Gerry Munroe ------------------------------