Im half way there... now what?

[balooka]

hi,

I have a simple DB with a few normal fields and 2 calc field:

Totaalwaarde -> Calc -> Unstored. =count(waarde::waarde)

Summary -> Calc -> unstored=(Max(totaalwaarde)

Totaalwaarde calcs the number of times the same value is added in the database. Its also searchable (so it can be used in a -find request). But how do I set a field that only selects 1 record instead of all. Let me clearify:

10 records with 'A' as a value in 'Waarde'

5 records with 'B' as a value in 'Waarde'

Totaalwaarde results in: 'A'=10 and 'B'=5

..All 10 records containing 'A' have that mark so if i do a find on the highest 5 (-max=5) it will show all 5 records from the 'A''s. Instead of ranking 'A' as 1, 'B' as 2 etc.

So i want to omit all in the same range (waarde) but one... or something ...

ThX jp

snippet of the htm I use:

[fmp-inlineaction: -db=test2b.fp5,-sortfield=summary,-sortorder=descending,-max=5, -find]

[fmp-record]

[fmp-field:recordid] -- [fmp-field:waarde][/fmp-record][/fmp-inlineaction]

[jeffer]

maybe it's an idea to attach your database files to this post? I think your story is much more clearer that way;)

jeff