I have a field in my tables where the guidance counselor would have to type in Notes about the student. For example, Alex is in Grade 1 and he have an offense wherein he pushed his classmate, that note will be saved in the database. And then when he turned Grade 6 he had another offense wherein he was caught cheating in exams. I would need to create another note for his actions.
What can I do to not overwrite the notes I entered when he was in Grade 1?
aishapot
-3
Junior Poster in Training
Recommended Answers
Jump to PostWithout knowing about the structure of your tables, you could have a table just for notes with a structure like
*Student_ID
*Incident_Date
NoteWhere * indicates primary key (compound key consisting of the first two fields). A compound key would ensure a unique primary key.
All 4 Replies
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
ChrisPadgham
113
Posting Whiz
bluehangook629
0
Posting Whiz in Training
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.