ChrisAnthony
Registered User.
- Local time
- Yesterday, 17:06
- Joined
- Oct 15, 2010
- Messages
- 20
Hi all,
I am working on a recruitment and selection program. Here is what it does in a nut shell. You can add a job posting to the posting table ie posting id, position title ect. You then select a outlook folder containing all the applicants and associated resume / cover letters.
You can then save all the information from the mail folder into the DB ie sendername, body of email ect. This is linked to the posting table one too many by the posting id.
You then have a table with all question related to each job position . ie meet education requirements, meet work experience ect.
I then have another table tblEvaluations that I want to store each evaluator rating for each applicant for each a specific position.
So what I have so far is a form that has the userid(current user logged in) and postingid (that they clicked on from main menu). Then I have a sub form with all the applicants that applied for the position.
Now what I can’t get to work is I can’t seem to link tblQuestions to tblEvaluations. So what i want is a save button that save the questions and the answers to tblEvaluations with the corresponding applicantid and userid.
I am not sure if this is clear but I hope someone can offer some insight.
Thanks,
Chris.
I am working on a recruitment and selection program. Here is what it does in a nut shell. You can add a job posting to the posting table ie posting id, position title ect. You then select a outlook folder containing all the applicants and associated resume / cover letters.
You can then save all the information from the mail folder into the DB ie sendername, body of email ect. This is linked to the posting table one too many by the posting id.
You then have a table with all question related to each job position . ie meet education requirements, meet work experience ect.
I then have another table tblEvaluations that I want to store each evaluator rating for each applicant for each a specific position.
So what I have so far is a form that has the userid(current user logged in) and postingid (that they clicked on from main menu). Then I have a sub form with all the applicants that applied for the position.
Now what I can’t get to work is I can’t seem to link tblQuestions to tblEvaluations. So what i want is a save button that save the questions and the answers to tblEvaluations with the corresponding applicantid and userid.
I am not sure if this is clear but I hope someone can offer some insight.
Thanks,
Chris.