Topic: Changing Location
I have imported a load of records, however, the records got linked to the wrong location, as the database contains two locations with the same name. Which is the best way to correct this. Can I update the survey_event table using SQL Management Studio, so that the location_key points to the correct location, with entry_date today? Or do other tables also need to be updated?
Grid references do not need to change in this case.
Surrey County Butterfly Recorder