Hi Ranchers, I have a simple form which takes in Student Details such as name, surname, address, etc and saves the data to a database. The studentID is automatically generated. I would want to do a check to see whether the typed in name and surname already exists because there is a possibility of entering the same details twice since studentID is an autoNumber. How can I check before updating. Please assist.
But you shouldn't only check for first and last name. Cause it is possibility that two people have the same name. Better check for something unique like the Student ID. Or take additional fields to check for uniqueness.
I think this is referred to as the logical key for that table. This is generally a set (or single) column in a table which also needs to be unique apart for the primary key. (Which is most cases is a sequence generated integer). Define a logical key for your student table and you would know what to search on!