As the image below shows I have two databases: classes and packages. A package contains all the classes in the portal list.

I need to flatten the file for a website, so I need one field in the packages db (selected in the image) that lists all the classes that come from the portal. I'd like to do this with a calculation instead of script, but I've been stuck on this problem for several hours. Anyone have a suggestion?

If you can concatenate the fields of each the related classes (the ones in each portal row) into one calc field, then you can make a VALUE LIST of related values, and you can use a calc field in your home file/table to manipulate that value list, which shows up by default as the list of values, sorted alphanumerically, with paragraph-returns between.

The function you'd need is ValueListItems(FileName;valueList)

A scan of other define-field posts about ValueListItems function may reveal more...

That was actually my first inclination and it worked to give me the list of all classes. I just couldn't get it to be restricted to only those classes showing in the portal. I'll go back and try that again though. Thanks.

Make sure you have "Show only related values" in your Value-List setup.

Thanks, I've got it working now. Very nice. Thanks for your help.