How to make an array of possible options with a field?

[marcel_olmo]

Hello everyone,

Somebody could help me about the following problem ?

I want to store in some kind of array the different values of a field.

First of all, I pretended to do it with ActiveDocument.Fields("myfield").selectAll and storing it in a variable. But this wasn't work, maybe because you only select stuff, no copying.

Somebody know how can I store in a variable, all the values of a concrete field?

Thank you very much.

Regards

Marcel

[Miguel_Angel_Baeyens · Accepted solution]

Hello Marcel,

You may try something like the following (untested)

Table:LOAD CONCAT(Field, ',') AS FIELD_CONCAT FROM DataBase;LET vVariable = FieldValue('FIELD_CONCAT', 1);

Regards

[marcel_olmo]

Hello Miguel,

your solution solves my problem.

Now I got what I want, a variable with all the values of a field.

Thank you very much. I hope that when I'm starting to get confident about QV, I would help as well.