Display Sub-summary in Browse mode - Listview

[H.P.]

Hi all,

Just wondering if it's possible to display sub-summary info in List view - browse mode?

So far, I'm able to display sub-summary data under Preview mode only.

This is how I want it to appear in preview mode:

Category Item

Application

1. Ms. Office

2. Ms. Word

Music

1. Cd 1

2. CD 2

Thx.

H.P.

[Ender]

You can't show sub-summary parts in browse or find mode. There are other tricks to getting this data, through the GetSummary() function or relationships. Picking which one depends on how your tables are set up and where you want to see the summary data.

[H.P.]

Thx for replying.

GetSummary doesn't work in my case because it returns only number, date, or timestamp data type.

Is there a way to get the value of a field currently in the sub-summary?

My database is very simple, containing 2 tables: Category and Item. Each item in teh item category is link to the category table through category ID:

Table Category:

Category ID

Category Name

Table Item:

ItemID

ItemName

CategoryID

Thx.

H.P.

[Ender]

If all you need is to see the Item counts for each category, you should use a Count(Item::ItemID) calc in Category.

You could use a calc GetSummary(Item Count; ItemID) in the Item table to show the counts of all items with the same ItemID, but the counts would only show up when the records are sorted by ItemID.

[H.P.]

In browse mode, the best I could display it is as follow:

Application ________ 1. Ms Office

Application ________ 2. Ms Excel

Application ________ 3. Ms Word

Music ______________ 1. Music CD 1

Music ______________ 2. Music CD 2

Music ______________ 2. Music CD 3

And this is how I want to display it.

Application

_______________1. Ms. Office

_______________2. Ms. Word

_______________3. Ms. Office

_______________4. etc..

Music

_______________1. Cd 1

_______________2. CD 2

_______________3. Cd 3

So far, I'm only able to do it in Preview mode with the category (Application, music, game) in the subsummary.

[Ender]

I can't think of an easy way to show that in Browse mode.

[csauve]

Check at the example Four on Filemaker Website

http://www.filemaker.com/ti/103815.html

[H.P.]

Thank you!!! It's exactly what I need :