By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 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


damonreid
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

missinglinq
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)
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)>
Jul 24 '07 #3

Post your reply

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