Variable in a Variable

[CPGDeveloper]

Hi All,

I don't know if this is possible, but I have a subroutine that populates the caption of a label. Something like this:

Forms!Form1!LabelTitle.Caption = titlevariable

'titlevariable' is defined by looking up the value in a table, and if the value in the table is a simple string, such as 'MANAGER', it works fine.

However, what if instead of passing the string 'MANAGER', I want to pass another variable.

So for example, if titlevariable = "anothervariable", which is also a variable. And anothervariable = "MANAGER"

In this scenario, is there a way I can write
Forms!Form1!LabelTitle.Caption = titlevariable, so that the caption of this label ends up being 'MANAGER' as opposed to 'another variable'?

 

[CPGDeveloper]

The variable in the situation I'm working through is a public variable, that has been declared and defined upon the application opening. And the value of that variable is different depending on who the user of the application is -- I was just trying to see if I could avoid some hard coding, but point taken -- this doesn't seem possible. Thanks for your time.

 

[Micron]

The only way I can envision getting around it would be to use the variable name as a PK field value as long as the needed value could be looked up from another field in that table. However, that would make no sense if the needed value was static as it might as well be like all the other records you have. If the needed value could be anything at run time, then I suppose the answer would be to update the current needed value that's related to the PK, then use it. e.g.
during run time, before value is retrieved:
ID/Title
1/Manager
2/Developer
3/CEO
4/strAnalyst

after new value is determined
ID/Title
1/Manager
2/Developer
3/CEO
4/SomethingElse