Import & lookup function
I have a database that performs a lookup against "last year's" version of the same database. During data entry the data can be overwritten so if things change it can be updated. Many records get brought into the data via import. During import, however, the value from "last year" overwrites the current year's data, even if the current data is different.
Is there any way to prevent this from happening, and keep the current data.