Thanks John²,

The last bit of code worked also, all I have to do is work on the formatting. You see the real problem is that I am trying to document...

Hi John,

Thanks alot - I actually like this idea and its a bit cleaner than working with sysobjects. However I am getting an error with getting the script to process...

Ok Cool, That being so how would I script to get my results to appear like:

PHARMA

CCITEM CCPDCL CCDESC

PH00001 PHAR desc1

AH00052 PHAR desc2

.

.

SD15225 PHAR descN

----------------------

DENK

CCITEM CCPDCL CCDESC

DF52451 PHAR descX

GH00001 PHAR descY

.

.

LP99999...