Custom Function Wanted

[Fuge]

Tricky one...

What I want to do is be able to get all the values of a field of a related table and combine them into a Cal field in the parent table.

For example

Related Table is called Contacts.

In this Contacts Table I have a field called Name.

Name:Record 1 = Dave

Name:Record 2 = Bob

Name:Record 3 = Tom

Name:and so one...

In the Parent Table I have a field called Contact list which is a calculation field. I want all 3 names combine into this field.

for example:

Contact list =

Dave

Bob

Tom

I'm sure this can be done, but I'm not sure how to get the cal field to read all the related tables fields and combine them. I realize I can create a list via a portal, But I'd like to get the names in a single field for Export reasons...

Many Thanks....

Dave

[comment]

The List() function does exactly that. But I don't think it's going to export very well.

[Fuge]

Yeap, That does it... Always some bit of a program you don't know about...

You're right about not getting the export results I wanted!

Thanks

Dave