can i subsummarize the portal records?

[mmonsalveg]

Hello , i have a database with a portal that looks something like this.

this is the portal

item qty

''''''''''''''''''

234 1

234 2

234 2

234 2

328 1

328 1

can i make it look like this? i need the item subsumarized by item number

item qty

''''''''''''''''''

234 7

328 2

please let me know

Thank you

Mauricio

[Ocean West]

here is one way to do it - but it requires FM 11 and filter portals - there are a few other ways but it requires FileMaker Advance and a custom function.

sample.fp7.zip

[comment]

You could also use the "Ugo method" (search for it), or show a portal to the Items table (filtered by a global field holding the current parent's ID). Neither require version 11 or a custom function.

Why do you need this? It's the purpose that determines the best method to use.

[Fitch]

This article shows how to do it, but again it requires FM11 filtered portals.