>>Frank,
>>
>>Unless I am missing something, this doesn't solve the problem I have. I am looping through the field collection and then replacing the caption with the VPM DD caption. At the end of this I want to sort the field collection on the file/caption.
>
>Jack, what I do is the following:
>
>First I clear the collection.
>Then I look if I have a metatable, if so, use that one to fill the field collection.
>But if it does not exist I fill the fieldcollection using
>SELECT SQL statements and loField=.oFieldsCollection.ADDITEM()
>Because the SELECT SQL is ordered, all AddItem() call are done in the right order.
>
>hth,

Thanks Frank. I will take a look at where I want to do an additem or try to do an Asort on the collection as Mike suggested. Either should work, I'll have to see which I think is easier.

Jack