Hi everyone:
I am building a Resume Database in Access 2000. I have about 7 tables linked together. I have a one main table called tblApplicantBioData. This table is linked with tblApplicantEducationInfo, tblWorkExperience, tblLocationPreference, tblEEOInfo, tblResumeHistory, and tblJobBank.
What I need is when Applicant have applied for certain job I need the position number to be entered to the tblResumeHistory table. Table tblJobBank contains JobID (Primary Key), PositionNumber, Title, Description, JobPostingDate, JobClosingDate, and ApplicantID (foreign Key) fields. What I need is when Appliacant have applied to certain job how do I make connection/relationship to both tables (tblResumeHistory with tblJobBank). HR will be entereing position number in the tblResumeHistory table manually - which should make connection to the tblJobBank table.
Can anyone help please how should I accomplish this?
Thanks in advance!
I am building a Resume Database in Access 2000. I have about 7 tables linked together. I have a one main table called tblApplicantBioData. This table is linked with tblApplicantEducationInfo, tblWorkExperience, tblLocationPreference, tblEEOInfo, tblResumeHistory, and tblJobBank.
What I need is when Applicant have applied for certain job I need the position number to be entered to the tblResumeHistory table. Table tblJobBank contains JobID (Primary Key), PositionNumber, Title, Description, JobPostingDate, JobClosingDate, and ApplicantID (foreign Key) fields. What I need is when Appliacant have applied to certain job how do I make connection/relationship to both tables (tblResumeHistory with tblJobBank). HR will be entereing position number in the tblResumeHistory table manually - which should make connection to the tblJobBank table.
Can anyone help please how should I accomplish this?
Thanks in advance!