Form for 2 tables (or more)

[monique10290]

Good Morning, new to Access Forums and a newbie to Access in general. I was given a task to create a access database to replace our excel tracking of applicants for our companies recruiting department.

The goal:
1. Track all applicants for 2 departments (Translation and Interpretation), sometimes they overlap and 1 applicant can have 2 or more applications.
2. Store all information about them: name address, languages they speak etc.
2. Track which contracts they have applied to work on. (again could have more than 1)
3. Track where they are in the process: Application, Interview, testing etc...
4. Track their test results: Pass or fail with eligibility to retest or not

Really doesn't seem too complicated but I think I am making it harder than it has to be. I created a information table, status table, a contract list table, a language list table. I created separate tables so that I can have drop downs to choose from for consistency.

What I want to do is have a input for that has all the field from the information table (with the drop downs) and then toggle button to the status table where I enter in each application they have submitted (this would store on the status table). Where do I put the testing information? The status table or should test results be yet ANOTHER table?

Am I making it too complicated? I attached a copy of the database with where I am at. Any input would be much appreciated! Applicant Tracking.zip

Thanks for any help you can give!
Monique

[ranman256]

sounds like you will need a tPerson table
with name, address, city... (applicant , or employee, etc)
&
tContracts table
tTests table
tAbilities table

all these child tables would link to the master table tPerson.PersonID field

tAbilities
----------
translation, or Intpret
language
etc

1 form would connect to the tPerson table
and the sub-forms would connect all others.
(use tabs) click TEST tab, to get that persons tests.
click Contract tab, to get the persons contracts.
(semi-easy)