How to correct data which are involved in integrity checks?
If you had accidentally mis-spelled data for the species name, trip name, location or birder name, and then linked one of these to the corresponding sightings table from the popup list, you cannot correct the errors in these fields directly. Access will report violation of relationship integrity and prevent you from saving the corrected records. To correct errors in these fields, you must first delete all records in the sightings table with the same field values. Then correct the error and add back new records in the sightings table with the corrected value. Back to FAQ index.
