I am creating a database to track student violations. One student may have
many violations so I have one table with the student data (their unique
identification number, their last name, first name, and residence hall). I
have another table with all the violation data (date of violation, type of
violation, sanction issued if any, etc.). Since a student may have more
than
one violation, is there a way that the student's last name and first name
can
auto-populate if I try to put in the same unique identification number?
That
way, if it is entered correctly once, I won't have to worry about
mispellings
of names.
Hope that made sense. Thanks.
|
