add all values from a particular field to a drill down group

[Anonymous]

Hi All.

Can anybody help me with this problem here...

Please let me know if there is a way to add all values to a drill down group from the field.

I am trying to find a way where a macro can run and read all the values from a field and add it to the group.

Thanks,
Aadil

[sbaldwin]

hi if you kept the field names in a column called META for example you could use this code to create the group STEVE:

sub createg
'activedocument.removegroup("STEVE")
activedocument.creategroup("STEVE")

Set val=ActiveDocument.Fields("META").GetPossibleValues(20000)
For i=0 to val.Count-1

activedocument.getgroup("STEVE").addfield(val.Item(i).Text)
next

end sub

Thanks

Steve