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

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

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.

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