Checking for duplicate data

[brock]

The databse I'm working on inputs students. I was wondering if there was a way for my database to check "First Name", "Last Name" and "Student Number" when inputted to see if that studentis currently in the databse.

Thanks for your time.

 

[ian_ok]

Why not set the student id number to: Yes (no duplicates), as many students do have the same name.

Ian

 

[Chris RR]

You can do a Dlookup to check for duplicate name, and you wouldn't be able to enter a duplicate student ID, if that's the key. But I agree with ian_ok, a duplicate name is certainly possible.

 

[brock]

thanks guys you're right...
thanks