In a table I have an EnumList column which is of type Ref to another table.
When I come to create an email template how do I parse the values in this EnumList to then return the values in the table to which it references.
My template looks like (also attached as image):
|<<Start: [Related instSessionLogs]>><<[instSessionID]>>||<<[FK_sessionID]>>||<<[FK_instIDCompletdBy].[Name]>>||<<[FK_groupIDs]>>||<<[FK_pupilIDs]>><>|
The field [FK_pupilIDs] is a list of the primary key field in the pupils table pupils.pupilID
This will return a list of values such as 123456, 234567, 345678
I would like to display the value in the field pupils.pupilName (e.g., Fred, Bob, Will)
Any ideas on where to start would be appriciated.