Valuelist --- show number of records!

[pitonius]

I've got a CDML problem!

I have a database (news.fp5)

In this I got a lot of records sorted by categories.

In the field categori I have set up a custom valuelist named categori.

And the categories are sport, news, etc

My problem is.

I want to have a list of the categories.

I also want to know the number of records in each categori!

Like this:

news (11)

sport (33)

Can someone help me!

[Keith M. Davie]

You have a problem, it is not a cdml problem.

Why?

You have a news.fp5 field named "category" which is attended by a value-list through a menu, check list or radio buttons on the layout you are referencing.

Do this. Make another layout in news.fp5; call it 'web' and place but one field on it, 'category'. Now (you are still in layout mode) open Format / Field Format... and select standard field. Go to Browse and you will see a word in category which relates to the checked item for the value-list which is used on the other layout in the record which you have accessed.

Basically this should demonstrate to you that regardless of the layout, you have one field 'category' which has in the case of a valuelist, a finite number of possible searchable data bits. So you can search and find all records for news. And you can search and find all records for sport. And you can search and find all records for each of those finite data bits of the valuelist individually. But can you search and find all records in that file and have that search break-down the "find all" or more properly "show all" by number of records per category? If you can't do it directly in the database file, how do you propose to accomplish this feat from the browser?

Helpful hint. Understand the similarities and differences of database file valuelists and format files which use html valuelists.

Peace

Keith