3 Replies Latest reply on Mar 27, 2015 10:17 AM by philmodjunk

    Connecting records through join table



      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?