AnsweredAssumed Answered

multiple names assigned to same record

Question asked by Nerico_1 on May 25, 2011
Latest reply on May 25, 2011 by philmodjunk


multiple names assigned to same record


I have a table for a schedule of lectures.  Each records has the information for a particular lecture including title, date, time, location...  Each lecture record can have up to 3 lecturers assigned to it.  There is a separate table with the info on each lecturer.  Right now, I have three fields where I store the IDs for each of the 3 lecturers from the faculty table.  FacID1, FacID2 and FacID3.  I want to have three corresponding calculated fields that will display the name of each lecturer,  FacName1, FacName2, FacName3.

My question is that I don't know how to set up or code the calculations to display the correct name.