Get Possible Values for a Field

[Anonymous]

Hi

Is there a way of getting the Possible Values of a Field.  [Taking into account the effect of selections on associated fields / tables]

As in a bit like GetPossibleCount(fieldname) , but I need the possible values returned not the count.

Best Regards,     Bill

[swuehl · Accepted solution]

Maybe

=concat(fieldname, ', ')

[#3]

Hi Bill,

I used it once to get the values in a listbox ,

But a used it in Macro,

as,

SET ProObject = ActiveDocument.GetSheetObject("Products")

valProduct = ProObject.GetPossibleValues

here "Products" is Chart Id of listbox,

and in valProduct you get the Array of All the Possible Values.

Check if it Helps You in anyway.

Regards,

Ravikant

[jerem1234]

Try this:

concat({<Field = P(Field)>}distinct Field, ',')

Hope this helps!

[Anonymous]

swuehl

Yup, perfect.

I just need to add the distinct for my scenario.

     =concat( distinct [Audit Stats Airline IATA Code] , ', ')

Many Thanks,     Bill

[#6]

Hi Bill

you can use GetFieldSelections(Fieldname)

best regards

Chris