Hello,

Does anybody know whether it is possible to construct a fieldname in a scriptstep? What I would like to do is to make a loop. In this loop there must be a scriptstep that pastes a result in a field. The name of this field varies all the time, for example the first time the field is 'result1', the second time 'result2' and so on. In order to do this, I would like to change the name of the field with some formula, e.g. 'result+a' in which 'a' becomes higher all the time.

I've already asked this question in the 'fields' thread, but I now realize that this is a better place (newbie after all)

Martin

You can't change the database structure on the fly like you want to (shouldn't need to), but there are other solutions that will work for you.

create a related db with 2 fields,

field 1 is variable_name Text

field 2 is result

relate it to your main db with a global

eg my_dyna_relation: global = variable_name

now when you want to "Create a field" you set the new name of the field into the global and then set the value of my_dyna_relation::result to the results.

This will create a related record wih the name and result you want.

Charles