1

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.

Harry Clarke
Surrey County Butterfly Recorder

2

Re: Changing Location

I would think you need both to update the Survey Event and Sample tables. Both hold the Location key and probably are best kept in line with one another. No other tables need changing.

Mike Weideli

3

Re: Changing Location

Many thanks

Harry Clarke
Surrey County Butterfly Recorder