Crystal Reports Field join

Message

   Hello.  Can anyone help regarding trying to join fields from two separate records?  It's more complicated than just doing a ToText formula, I believe.

For example, I can have three records with one parent account number, but with two "child" account numbers.  So, my records initially show like:

Parent           Child
123456         111111
123456         222222
123456         333333

What I would like to do, though, is on the report, on one line, reflect it like:

Parent          Children
123456         111111,222222,333333

Any help would be appreciated!  Thanks, Mike