I have a database with more then 600 fields.

For the users I have made some preselected exports they can select from (nodialogs, straight into a excel-file).

But I want them also the have the possibility to choose from a selected list of fields. I have made a custom valuelist with the fields they can select. I have found the method (patterncount, etc.) to see which fields the users want, but then?

If I make tmpfields and fill them with set field I have to do that for each record. Is there another way to solve this problem?

Thanks

Bea

You could use unstored calculations of GetField(globalFieldX), where globalFieldX is one of the fields which contains a member of the selected field list.

You could also use a repeating calculation field that retrieves one member of the selected field list per repetition, then use GetField(GetRepetition( calcRepeating; X )), and change X for each field definition.