Please bear with me as I try to explain what I need to do... I'm not sure it can actually be done, but I am hoping someone will tell me it can...
I need to be able to create a report, by instructor name, that shows all of the projects a particular instructor has worked on - each project has a specific number id. The problem is that we may have up to six instructors listed per project, so Jane Smith, for example, might be instructor 1 for one project and instructor 3 for another. Instructor fields are labeled Instructor 1 FN and Instructor 1 LN (two separate fields).
Ultimately, I'd like to be able to enter the instructor's name and have a list of all projects she's been a part of regardless of her instructor number. Is this possible? If I need to clarify anything in order for you to help me, please let me know, I am really stumped!!