I have student table with studenID field , last name field, first name field. And I have another table with studentID field, code field.
On the form, user enter studentID then i will show up that record, then user input data on code filed on the form.
My question that, if the user enter the same studentID then I would like to see a message box show up that this student already have data input (to prevent duplicate)
Please help. Thanks