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):
sessionID: <<[sessionID]>>
FK_InstIDCompletdBy: <<[FK_InstIDCompletdBy].[Name]>>
FK_LocID: <<[FK_LocID].[Name]>>
Date: <<[Date]>>
FK_InstID-SI: <<[FK_InstID-SI].[Name]>>
FK_InstID-FA: <<[FK_InstID-FA].[Name]>>
instSessionLog
instSessionID | FK_sessionID | FK_instIDCompletdBy | FK_groupIDs | FK_pupilIDs |
---|---|---|---|---|
<<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.
Many thanks
Paul