one field based on another

R

rob

if one value keyed in one field doesn't match another display an error message.
I have to create one form with two fields student id and total mark. This
info is then sent to another person who tabulates the subtests of the exam ,
tallies them up and enters the total which should match the first total. If
it doesn't we need to display an error message. I guess i will need 2 forms
in the same database or is it better to have two databases and link them on a
query that updates automatically please help
 
Top