I would suggest to make a text-calculation (InstructorID_list) in TBL A:
InstructorID_list = List ( TBL B::InstructorID ) .
This results in a multikey which you can use to relate to a second TO of TBL C (TOname = TBL C2):
TBL A::InstructorID_list=TBL C::InstructorID
And finaly gather the names of the instructors with:
Substitute ( List ( TBL C2::InstructorName ) ; [ ¶ ; "," ] )
hope this helps
Thanks a ton. Your given solution works perfectly.