>Looping through the field collection and getting the caption from the Promatrix data dictionary and setting the caption.

I don't know Promatrix, but I think there's a better way to do this. I would subclass the sfFieldCollection class in SFQuery and change the GetCaption() method. Then, specify using this class in the cFieldCollectionClass and cFIeldCollectionLibrary in SFQuery.

>I would like after setting all the captions to order the fields by caption name within table. Any ideas?

Can't you just ASort() the collection? Or do you mean a sort like:

tablea
fielda
fieldb
fieldc
tableb
fielda
fieldb
fieldc

Then, I'd create another column in the collection, based on table + field and sort that.