Getting related values into a field

[Hendrix]

Hello

Maybe I'm missing something obvious, but I haven't been able to figure it out yet.

Is it possible to get the values of a field in every portal record into a single field in the parent record? I mean, if I have 3 people with their phone numbers (child records) in a portal of a certain group (the parent record), can I create a calculation field for the group so that the result is "Phone (rec1) & Phone (rec2) & Phone (rec3)"?

Thanks for any help you might give me and excuse me if the question is too obvious or has already been answered

Best regards

Hendrix

[Søren Dyhr]

Is it possible to get the values of a field in every portal record into a single field in the parent record?

Yes, but then the everlasting "Why" ...you're asking for help in denormalizing the structure!!! Why not making another portal for showing the phone number field only?? I think I know the answer - you wish to make a search in the field and unstored searches can be daunting.

It can be done as I demonstrate in the template attached!

--sd

clientBase.zip

[Hendrix]

Maybe I'm complicating things a bit, but the idea is as follows.

The database I manage stores information on several courses. It is mainly used as a database and accessed both via FileMaker Client and IWP. But then, once a year, I have to export part of the information so it can be published in a booklet. I guess there must be some cool way of doing it and automating it via XML/XSLT, but for the time being I need a simpler solution. I've set up a series of text calculation fields that gather and pull together the data I must export, give it some very basic formatting (line breaks and so forth) and then export it into a text file, so it can be formatted in a word processor.

Everything has worked fine, except that I couldn't get every value from the portal (I get the first one). That's the Why.

Thank you very much. I'll give a look at the file right away.

Manuel Aguilar Hendrickson

[Reed]

You could create a subsummary report in the phone numbers table (the many table) and instead of exporting from the contacts table, export the values from the numbers table.