Combine records from a portal in one field

[MacConsulting]

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?

[ESpringer]

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...

[MacConsulting]

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.

[ESpringer]

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

[MacConsulting]

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