Dynamic fields

[Kwaska]

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

[Charles Delfs]

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