I have a dataset containing some events. One of the details in the event is a topic of discussion. Each topic id is contained in a different collection-topics, which has a topic id to subject id mapping. Finally I have a Subjects collection, where the display name of subjects are stored against each subject id.
I want to display the subject for each event in a repeater. I have tried to filter the topics dataset with topic Id in my events dataset and then filter my subjects collection with the subject Id of the topics dataset. However, since this is twice removed from the events dataset - which is the primary dataset attached to the repeater- the same subject name is appearing across all the elements of the repeater, rather than change with the topics in each event.
Any help on how to resolve this?
Thanks
Sid