Maintaining multiple records for one individual (formerly Database)

[ssledgeo]

i have a database in ms access. i keep medical information of applicants.
in some cases some applicants take the medical exams twice. how do i keep this two records and mentain a unique id for the person.

[damonreid]

You can do this two ways.
One is to take the date of the input information and the user ID as the primary key.
The other is to make a seperate key.

[missinglinq]

In general terms your database would need to be set up with two tables, something like this.

Applicant Table
Applicant Name
ApplicantIDNumber (such as SSN - This would be Primary Key)
StreetAddress
City
State
Telephone

Exam Table
ExamIDNumber (This would be Primary Key)
Date
ExamSubjectIDNumber (This would be Foreign Key)
Exam Results

The two tables would be tied together by the
ApplicantIDNumber - ExamSubjectIDNumber fields.

Since you are new to the forum we would ask that you read the following posting guidelines, paying close attention to the section on giving an appropriate title to your posts!
(POSTING GUIDELINES: Please read carefully before posting to a forum)

Good Luck and Welcome to TheScripts!

Linq ;0)>