Ok my friends have a copy of an excel spreadsheet. As I get periodic updates, I am importing the spreadsheets into Access.
here is a sample:
first name / last name/ address / city/ state/email/phone/contact pref
(etc)
Now 3 people have the list that has nothing but first name and last name.
Here is the problem. Person 1 sends me their updates, which has some fields updated maybe 5 emails for different people.
Later, person 2 sends me updates. Problem is they have updates like several addresses, but they dont have those emails that person1 had updated, in the data they sent me.
Now if I try to run an update with the person 2 data, the emails from person 1’s updates will be updated… to the empty field of person 2’s data. It deletes that previous update in a sense.
Any suggestions of what I should do?
I would like to send period updates to the other 2 people working on this, but thats what I’ve got at the moment.