AnsweredAssumed Answered

Connecting records through join table

Question asked by JuliaOlsen on Mar 27, 2015
Latest reply on Mar 27, 2015 by philmodjunk


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?