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 ta...
Forum Discussion
Just tried it from my side and it seems like it works. I'm trying this formula:
SumValues(GetRecords("{1211.TV.'"&[Adviser_2]&"'}AND{2723.LTE.1}AND{2716.EX.1}",[AliasTest2]), 2716)Where the AliasTest2 field, is a Formula - Text set to
[_DBID_DEVTEST]Let me know if you keep encountering issues, but from here, seems like your method should work OK!
------------------------------
Lordsman Burgos
------------------------------
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
------------------------------
