I'm making a Applicant Record Keeping System. I'm a newbie with MS access. And i'm having a really hard time understanding how queries work.
I have three forms: (Sequentially)
So, this forms are for one applicant and they have common details.
Background Checking's common details with the other two are Name of Applicant and Position Applied For.
Background Checking's common detail with the Criteria Name of Applicant, Position Applied For, Date of Application, and Conducted by.
Criteria's common details with Document are Name of Applicant, Position Applied For, and Vessel Type.
So, I want them to link with each other. So everytime i go to the next form I won't type the common detail again.
I tried making ID's for them, and designed queries. But it's wrong.
Please help me...