cretool

Help Please!  Complex Join Tables

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

Hi,

 

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.

 

Thanks,

Don

 

Job Candidates Schema.png

 


Outcomes