Help Please!  Complex Join Tables

Discussion created by cretool on May 27, 2012
Latest reply on May 28, 2012 by cretool



I need to create a database in which we can match the talents of job candidates to the position. See the attached for the sample database and schema.


What I need to accomplish is to link Projects to Job Requirements and then how each Candidate scores on those Requirments.


I've created a simple form that creates a project and then the Job Requirements of that Project. Of course I have a form for creating the Candidate records.


What I'm stuck on is the form that brings them all together. Ideally I would be able to select a Project from a pull-down list. This would then populate the portal with the Job Requirements created on the other form and then allow me to select a Candidate that I could grade for each one of the Job Requirements. It would keep the Score for each Candidate, for each Job Requirement, for each Project. That's my ideal, but I'm a ways from that.



All help is greatly appreciated.





Job Candidates Schema.png