Hmm, I need some help.
I have a table that is keeping student report cards and I need to check if a student Id has already been entered for a class already.
The situation is that there are several students per class, and several hundred classes. Each student has a unique ID number and each class has a unique Class Code. The primary key is an autonumber. A student may have taken several classes (so I must allow duplicates in this field) and there are several students to a class (so I must allow duplicates in this field too).
I like to have all the report cards in one place so we can easily track student progress and records.
Everything with the database has been proceeding smoothly for several months now, but my data entry staff have made a few mistakes with the entry and have entered a student Id twice for the one class.
Can I create a warning message in my form that tells the staff that they have already entered a report for this student in this course, and to check the id number and class code again?
Thanks for any help you can offer.
tm
I have a table that is keeping student report cards and I need to check if a student Id has already been entered for a class already.
The situation is that there are several students per class, and several hundred classes. Each student has a unique ID number and each class has a unique Class Code. The primary key is an autonumber. A student may have taken several classes (so I must allow duplicates in this field) and there are several students to a class (so I must allow duplicates in this field too).
I like to have all the report cards in one place so we can easily track student progress and records.
Everything with the database has been proceeding smoothly for several months now, but my data entry staff have made a few mistakes with the entry and have entered a student Id twice for the one class.
Can I create a warning message in my form that tells the staff that they have already entered a report for this student in this course, and to check the id number and class code again?
Thanks for any help you can offer.
tm