I'm not sure if this is possible. I need to spin thru the following table summing NBR by TITLE. The table shows categories, some are "details" (type A) and some are "combinations" (type B). Details make up combinations, and for each detail category line, the "combinations" column contains which combinations they go into.

The report I'm trying to make would show the following:

For each "A" type, I show NBR and TITLE. For each "B" type, I show NBR, TITLE, and the respective DETAILS that it consists of. Problem is, the details are scattered throughout the entire table.

Representation of data:

IND NBR TITLE COMBINATIONS
---------------------------------
A 101 title1 B 103 B 105
A 102 title2 B 103
B 103 title3
A 104 title4 B 103
B 105 title5
A 106 title6 B 105
A 107 title7 B 103 B 105

Desired report output:

NBR TITLE DETAILS
-------------------------------
101 Title1
102 Title2
103 Title3 101, 102, 104, 107
104 Title4
105 Title5 101, 106, 107
106 Title6
107 Title7

Would I need to run thru once, table the NBR & TITLE, create a hold and then run through again looking for detail matches, or can this be done in one pass??
Thank you to any ideas.

This message has been edited. Last edited by: CD960,

What's your MFD look like? It looks like your data is rather random, is it really?

Post a copy of your MFD for us to see.

Yeah, it does look a bit messy, but the data is actually that random. What holds it together is a sequence number that I didn't mention, which will not be displayed in the output. This is the MFD:

SEGNAME=ONE,SEGTYPE=S0,$
FIELD=SEQ_NO , ,A4 ,A4 ,$
FIELD=CAT_TYPE , ,A2 ,A2 ,$
FIELD=CAT_NBR , ,A4 ,A4 ,$
FIELD=CAT_NAME , ,A36 ,A36 ,$
FIELD=CATEGS , ,A150 ,A150 ,$
SEGNAME=TWO,SEGTYPE=S0,PARENT=ONE,POSITION=CATEGS,OCCURS=25,$
FIELD=GEN_CAT_TYPE, ,A2 ,A2 ,$
FIELD=GEN_DETL_CAT, ,A4 ,A4 ,$
FIELD=CATS ,ORDER ,I2 ,I4 ,$

I would suggest TABLEing out the details, Seg two, and creating a file that you can join to.

Then join CAT_TYPE + CAT_NBR to GEN_CAT_TYPE + GEN_DELT_CAT.

From there you can build the list of NBRs.

Waz,
Thanks for the tip, I figured it would be tough to do this in one pass. I'll see what I can do with a join.
Chris