Cant seem to link tables

[ChrisAnthony]

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.

 

[YNWA]

Do you have tblQuestions ID in the tblEvaluation table as well?

You then link tblQuestionsID to the tblQuestionsID.tblEvaluation

Would it be possible to store the questions in a different table such as jobs?

 

[ChrisAnthony]

Here a little diagram of what I tried to do by linking subforms.
The problem is that I cant get the last subform to link all the required fields. When I get
through the wizard it only allows me to select fields from subform2?
I know this is possible and most likely fairly simple.
Main Form tblUserPostingFEILDLINKED FROMfldUserfrmUserPostingSelectfldPostingfrmUserPostingSelectsubForm1 tblApplicantsFEILDLINKED FROMfldNameTablefldAttachmentsTablefldPostingfrmUserPostingSelect.fldPostingfldApplicantTablefldDateReceivedTablefldBodyTableSub Form 2 tblQuestionsFEILDLINKED FROMfldPostingtblApplicants.fldPostingfldQuestionTablefldTypeTableIDTableSub Form 3 tblEvaluationsFEILDLINKED FROMfldApplicantstblApplicants.fldApplicantsfldPostingtblQuestions.fldPostingfldUsertblUserPosting.fldUserfldQuestyp tblQuestions.fldTypefldQuestiontblQuestions.fldQuestionfldAnswertablefldQidtblQuestions.ID


If someone was willing to take a look PLEASE message me @ chrism_6_6@hotmail.com
Thanks
Chris.

 

[YNWA]

zip up your database and post it in an attachment.

 

[ChrisAnthony]

Thank you so much

 

[ChrisAnthony]

Thanks again...

 

[ChrisAnthony]

Hi there,

Sorry I sent you a old copy of the DB its a bit sloppy. My have guessed is that basically I want to display all the questions related to the posting and then in table evaluations I want it to display the related answer from the user related to the posting selecting and applicant selected... if there is no record that meets that criteria in the table then i want it to add record in table evaluations to record the answer.

My problem is when I add the table to these forms and go through the wizard I cant select criteria from multiple sub forms only the master.

this so frustrating! I know this sounds simple enough but being a novice with access I cant seem to figure this out!

 

[ChrisAnthony]

If someone can can make this work for me I would be glad to compensate!

 

[ChrisAnthony]

here is a 2003 version.... So again just to restate i need to get all the linked variables from 3 forms to be saved into the evaluations table. So basically I want the user id,question and answer to be saved into evaluations. PLEASE SOMEONE HELP! I am very desperate to get this working.

 

[ChrisAnthony]

Anyone that can provide me with a solution ill give them $100 as a bit of incentive