Alen Browne's Concatenate, can returned concatenation be used as a reference

[tarenja]

I recently received help to get the Alen Browne cancatenation function working in my application and I really appreciate it.
Typically the cancatenation returns values like: 7, 8, 21, 22
These values are the id's of activities selected by delegates at a conference.


I now need to use these activity id's to reference the actual name of the activies which are in a related table.
Can anyone advise me of the best way to loop through the values returned by the concatenation (this may be 0 or up to 15 values) and use these as a reference in a related table.

[June7]

Better to include the names up front in a query joining tables and concatenate the names instead of the IDs. The procedure can use a query as source data just as well as a table.