2 teachers 1 class

[snu]

I have tblFaculty, jtblFaculty_CourseSched, tblCourseSched

Up to this point I have had only 1 instructor per course. I now have a case where there are 2 instructors teaching one course. I have the following fields in tblCourseSched: FacultyID, CoursesID, DaysID,Time, LocationsID, RoomID,SemesterID.

I have just added FacultyID2 to the table to list the second instructor.

I am trying to add FacultyID2 to the entry form that feeds the table, but keep getting error msgs. I have a control labeled FacName1 for first faculty and I tried to create a duplicate control for FacName2. I am breaking some kind of rules bc I keep getting errors no matter how I try to set it up. How can I list the 2nd instructor? Was adding another FacultyID field to my table the right way to go about this or am I missing another solution?

How should I/can I add it to the form?

 

[snu]

Okay so I got the Form to work and I am able to input two teachers into the form and it is putting the data into the table.

Now I am trying to make a FacName2 field on my report and getting errors.

 

[CEH]

Did you add the field to the query behind your report? If so you will need to explain what error for anyone to help.

 

[snu]

Here is what I tried putting in the query. Each one is in a separate column. I also tried putting them both in the same column by listing one instructor-several spaces- second instructor, but something must have been wrong with my syntax. I did adjust column length etc. I also went about this by adding a copy of tblFaculty, which I think is probably not the correct way to do this. I can upload a copy of my db if someone can direct me to that db cleaner tool again.



FacName1: IIf(Len([FacultyFirstName]![tblFaculty] & "")=0,[FacultyLastName]![tblFaculty],[FacultyLastName]![tblFaculty] & ", " & [FacultyFirstName]![tblFaculty])


FacName2: IIf(Len([FacultyFirstName]![tblFaculty1] & "")=0,[FacultyLastName]![tblFaculty1],[FacultyLastName]![tblFaculty1] & ", " & [FacultyFirstName]![tblFaculty1])