Updating same record at same time

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I've developed a simple report card database that
includes a narrative memo field that is meant for
completion by various teachers on different subjects.
What I'm concerned about is what will happen when two or
more teachers attempt to enter data in the narrative
field in the same record at the same time. If this is a
problem,is there a procedure or macro or something that
can prevent one teacher from entering info in the
narrative field until no one else is using it?
 
You need a separate table for TeacherComments, each teacher would complete
one record with his/her comments for each student per grading period:

TeacherComments
-----------------------------
ReportCardDate
TeacherId
StudentID
Comment

This is easily presented in a subform of the report card form.
 
Back
Top