Hi,
I have a problem and it is very very important for me to come over it asap. I would sincerely appreciate if you can help me technically.
I have two databases in MS Access 97. One has a primary key which is a number and the other database does not have any primary key.
Both the databases have information about
a huge number of people.
The task I have in front me is to combine these two databases together and obviously to provide a primary key.
The problem is that there are some people who are common in both the databases, so I can’t simply merge(the two tables that hold person information) them together as it may result in a same person can hold more than one record. I do not how I can solve this.
Also please let me knowwhether I can implement the following idea:
Can I pull the first name and last name of each person from a table in database2 and compare it with first name and last name of each record in a table in the first database1(which has a primar key for itself) and then assign a new number(for primary key )if no record matches, else I assign the same primary key incase it matches. If you think this works please tell me how I can implement this.
I hope you understand my problem. My email id is bommal@onebox.com and I would be more than happy to provide any further information.
Thanks in advance,
Warm regards,
Bommal.