Hello all!
I am having trouble figuring out a way to search data and there really might not be a way.
Here is the problem.
I have a database that I made for my department. It has customer information in it. My company has a different database that houses customer information, and new sales information.
Without the use of any unique identifiers (like CustomerID) I need to get the sale information from their database to my database.
Here are the fields that both databases house.
SSN
Name
Address fields (City state and Zip)
Oh and to make matters a little worse, I can have the same customer twice (or more) in my database and they can have the same customer twice(or more) in their datbase.
Any help on this is appreciated! I can also use stored procedures or vba if it would make this easier.
Chris
I am having trouble figuring out a way to search data and there really might not be a way.
Here is the problem.
I have a database that I made for my department. It has customer information in it. My company has a different database that houses customer information, and new sales information.
Without the use of any unique identifiers (like CustomerID) I need to get the sale information from their database to my database.
Here are the fields that both databases house.
SSN
Name
Address fields (City state and Zip)
Oh and to make matters a little worse, I can have the same customer twice (or more) in my database and they can have the same customer twice(or more) in their datbase.
Any help on this is appreciated! I can also use stored procedures or vba if it would make this easier.
Chris