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.