It's called name expression (see help for details)
STORE fieldvalue TO ('newvar' + TRANSFORM(m.x))
>I have a need to create a variable on the fly that I can increment within a do while loop. The first pass it should be assigned as newvar1 with a value stored from a table. Somehow I'm unable to get the syntax correct. Where "x" is the value being incremented as it begins to loop back through, I need to attach the value of "x" on to the end of the variable name. In essence my mind goes to something like 'newvar'+m.x=(field value). I've reworked this so many different ways I'm beginning to think it can't be done. But, that seems ridiculous since this would be perfect for what I need. And I'm ok with the str() and val() commands required to make the number play nice with characters, I'm just putting it all together wrong and getting syntax errors. Any and all help is greatly appreciated, if only to maintain my fragile sanity.
>
--sb--