Table field calc to concatenate related record names from IDs

[Jasmine]

Hello,

I'd like to add a field to my Images table with a calculated list of Subjects that appear in the image. I'd prefer it as a calculated field in the Images table so it can be added to a portal in a different database which selects multiple Images for something like an album.

Data Structure w/ Relevant fields:

Images table

-ID

ImageSubjects table (record creation/deletion by Images allowed)

-ImageID (joined with Images::ID)

-SubjectID

SubjectsList table

-ID (joined with ImageSubjects::SubjectID)

-Name

Data entry in Images allows the selection of multiple Subjects via a portal.

Here's what I'd like to do in pseudo-code:

foreach ImageSubjects::ImageID

where ImageSubjects::ImageID = Images::ID

push @Subjects, SubjectsList::Name



return join ", " @Subjects

Is this possible?

Thanks!

Jasmine

[comment]

Try:

Substitute ( List ( SubjectsList::Name ) ; ¶ ; ", " )

[Jasmine]

Thank you for the suggestion, but that yields an empty field. Perhaps I'm missing a relationship?

[comment]

No, it should work with the relationships you have described. Make sure you are using a calculation field with the result type set to Text, and that you do have related records.

---

And that the calculation field is defined in the Images table, of course.

Edited October 12, 2008 by Guest

[Jasmine]

I should have know that I did something silly. It worked perfectly... thank you!