Connecting records through join table
I am director of a program which interfaces between teachers and business through summer industry work for the teachers. I have one set of records for teachers, and another set for businesses. The connecting table is the summer work.
I have been, in the past, creating summer job records through the teacher side, which successfully appear in the business records through a portal so I can quickly identify all the teachers that are at a particular company.
Now I have need of ALSO creating records through the business side, and then having the ability to assign a teacher to a particular summer work record. So far I am just getting two sets of summer work records - one shows up for businesses, one shows up for teachers. I suspect I need to have a 2nd copy of the summer work table so I can pick the business/job description for the appropriate teacher, but haven't been able to get it to connect properly.
I hope I have explained this succinctly enough. Help?