Re: subform parameter links

First of all, maybe you ought to fix the Contact entry table to only enter
companies that are listed on the company table. You do this with a combobox
tied to the company table, so there are no illegitimate entries in your
contact list. You may have to amend the contacts table to include the
foreignkey for companies. If this is not feasible, then check out the help
files for the LIKE operator in VB or a sql statement.

Damon


"JB" <JB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A119F982-D0BA-4C8B-A4BB-B9B3D349EAA8@xxxxxxxxxxxxxxxx
I have a form that contains contact data from table1. I need to check
another
table (table2) to see if the Company is included in that table. However,
the
Company name may vary slightly. How can I do a 'fuzzy' search?

example

Table1 company name is The ABC Company
Table2 company name is ABC Company Ltd

or

Table1 company name is ABC Company PLC
Table2 company name is The ABC Company Ltd



.