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.