Hi everyone,

I could not find a topic on this. Can I make a portal summarize my records?

In other words, I have a descriptor field and a qty field. I have many records with the same descriptor (2pvc for example). I want the portal to show 2pvc only once with the summary field of the footages. How can I do this?

thanks in advance

Portals are built to show all the related values. You can create a summary field in your join table to display the summary information in the portal.

How you can show only one descriptor?

In your related file you may have to add a field to discriminate between the original and duplicate values. See filemaker pro help on show duplicate values.

Then create your relationship in such a way that it should only pick the original values. That way you will have one unique record for each descriptor.

You can not see the summary data but you can see the number of records for each descriptor.

Hope it helps