Hi,

I have a table that contains two fields. One is a unique id and the other is a company name. I also have a form that allows users to add company names to the table. Right now I have code that checks to see if the company has already been entered by comparing the value entered versus the table column for company name. However, this is not very effective. For example, the company name 'Turner Construction' could be in the table and the user enters 'The Turner Construction Company' or some derivative of this and it would not result in a match. Can someone please provide a suggestion on how to better handle this.

Thanks in advance for your help,

Russell