View Single Post
  #5 (permalink)  
Old March 21st, 2007, 11:58 AM
pallone pallone is offline
Friend of Wrox
Points: 1,243, Level: 13
Points: 1,243, Level: 13 Points: 1,243, Level: 13 Points: 1,243, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2003
Location: , , United Kingdom.
Posts: 290
Thanks: 24
Thanked 0 Times in 0 Posts
Default

I will have two tables. These tables will have company records like ID, Name and MaxValue.

Unfortunatly, the IDs will not match since one table comes from one country and the other table comes from another. However, they represent the same company.
I know this is stupid but that is the way it is and I would love to find a solution so that I didn't need to go record by record manually.

Therefore, I will have to check for the same company name or a simiar company name in the Name column. I say similar because people in one country may type an abbreviation of the company name whereas people from another country would write the full company name.

What a lack of referential integrity isn't it?

Well, thanks for you help

CPall
Reply With Quote