avoiding double entry in table

  • Thread starter Thread starter hermie
  • Start date Start date
H

hermie

Hi I have a small table that records the absents of students in my school
Field names are: IDabsent, social sucurity, date_absent, reason

How can i avoid that an asbent of a student is entered twice?

Hermie
 
How would you know if the absence was entered twice? If the social and date
are repeated? If that were the case, you could make the social and the date
combined your primary key field.
 
How would you know if the absence was entered twice? If the social and date
are repeated? If that were the case, you could make the social and the date
combined your primary key field.
Click to expand...

Or, you can combine the fields that need to be unique into a Unique
Index. This lets you use an AutoNumber primary key for simplicity, but
still enforce uniqueness on one or more other fields.

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com
 
Back
Top