I have to occasionally import 3 new data columns from tblX to tblY, however, tblY contains data that is manually input that I do not want to lose. I have tried moving the manual input data to a temp table and then back after the import, but only end up with dup rows, etc... Do I need Primary Keys set upa certain way, or is it dependant on the relationship between the two tables (i.e. Referential Integrity, Cascade update, etc..?
I would greatly appreciate any assistance!
Appreciate the reply ... I should have been more specific in the original post (I was pulling an all-nighter).
I am dealing with individual records identified by a unique customer ID number. So, should I move the manual input data to a temp table, import their 3 additional info columns (downloaded from a main data system) and then move the "manual input" data back? If so, does the cutomer ID number need to be primary key in both? I don't think I can use an update query because that requires you update an entire column (for all records) to the same value, right?
I am very new to the SQL side of queries ... the light is dim but it is getting brighter! I made it work on the front side of the query though using your recommendation.
(note to self ... must learn SQL)
Another option is to keep the data in two tables, and link by customer ID. I've done that where one table is for manual entry and the second is for data downloaded from another source. It makes it easier to append, or even use a make table query when it's easier to start over each time.