parent database and child database related through a standard
relationship.

Is it possible to have a calculation field in the parent file, which
will basically concatenate all the child records?

More specifically...
the parent file is called company.fp5, the child file is called
classification.fp5
Can I make a calculation field in company which will list all the
related records from classification.fp5 in alpha order?

Company.fp5 and classification.fp5 are related through a company id
field.

Thanks

Batfastad

"Batfastad" <whatever@noway.com> wrote in message
news:np3Wb.1838$Y%6.331979@wards.force9.net...
> parent database and child database related through a standard
> relationship.
>
> Is it possible to have a calculation field in the parent file, which
> will basically concatenate all the child records?
>
> More specifically...
> the parent file is called company.fp5, the child file is called
> classification.fp5
> Can I make a calculation field in company which will list all the
> related records from classification.fp5 in alpha order?
>
> Company.fp5 and classification.fp5 are related through a company id
> field.
>
> Thanks
>
> Batfastad

Hello,
You can do that with the ValueListItems design function, although there are
some limitations as to the number of characters per line. I don't remember
the specifics, but this was discussed a few months ago, so you should be
able to find the thread.
First you have to define a value list using values from the related records
(maybe a concatenation of some fields in the child file), and then you
define your calculation with the ValueListItem function.
If this won't work, because of limitations, you can also use a script to
loop through the related records (or portal rows) and set a field to itself
& "paragraph"  & (field from current record in the loop).

HTH

Marc-Andr� Paiement