Field that Combines the Rows of a portal

[DrMonkey]

I have a client tracking database in filemaker that keeps track of my clients.

I have a tab that has a portal that keeps track of their criminal charges. Each row has case number and description.

I would like to use filemaker to print my file labels for my client. The label will show what charges the client has.

Is there a way to use the data stored in the portal to create a summary field that can be used on the label?

For example:

Client: John Smith

Case Number and Description fields in portal:

07-M-123 DUI

07-M-124 No Insurance

07-M-125 Obstructing an Officer

Based on the above portal, I would like my file label to show:

DUI, No Insurance & Obstructing an Officer

Any ideas?

[bcooney]

Create an unstored calc field (text) in Clients, List(ParentTO::ChildTO Description) which will gather up all the descriptions for that Client into a paragraph delimited list. Put their Name and this field on a label layout.

But, won't the label become outdated as soon as you add another charge?

[DrMonkey]

That is wicked!!! Thank you.

Any new charges will require a new entry into the database and a new file including a new file label, so there is no worry of the labels getting outdated.