2 subsummary parts only sorting by the first

[Eliz309]

I have a layout containing 2 subsummary parts in a database containing different products. The first should sort on a broad type (for ex: cables) the second should take the cables and sort them by cable type (ex: audio, video, etc.) and display the information for the 1st item in the list. Then under that subsummary it would show a list of all of the Cables that were audio. But for some reason it is losing it on the 2nd subsummary.

It should be

Cables

__Audio

____Audio 1

____Audio 2

__Video

____Video A

____Video B

But what it is doing is

Cables

__Audio

____Audio 1

____Audio 2

____Video A

____Video B

Any idea what I am doing wrong?

[-Queue-]

Can you zip or stuff a small copy of the problem file and attach it here for us to investigate?

[Eliz309]

Here is a small copy of the file. The main page opens. then sort by the "short description" field based on Value List "Ultralink" then sort field "sku" ascending. Then go to the ultralink layout. I'm still working on this so please excuse the mess. Thanks

ProductCatalog.zip

[-Queue-]

The attachment isn't a valid zip file. How did you create it?

[Eliz309]

I used the Zip feature that comes with Windows XP. But I did figure out what the problem was. I was trying this out with a previously created field that wasn't yet being used. It was a number field. When i made it a text field then everything worked out. Thanks anyway for your help.