By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,166 Members | 1,130 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,166 IT Pros & Developers. It's quick & easy.

Maintaining multiple records for one individual (formerly Database)

P: 1
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.
Jul 24 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 114
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.
Jul 24 '07 #2

Expert 2.5K+
P: 3,532
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)

Exam Table
ExamIDNumber (This would be Primary Key)
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)>
Jul 24 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.