Having investigated further I feel that a bidirectional relationship between the cast member and the event will work best. However, I cannot seem to find any information in relation to bidirectional relationships within a repeater. I require a repeater so that I can have a list of multiple cast members assigned to different characters.
Is this something that can be done? I have noticed a few other help topics on this that have had no answers. Obviously, this is something people want.