subform parameter links

[Guest]

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

 

[Damon Heron]

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

 

[Guest]

Thanks Damon.

There are no illegitimate entries. Table 1 contains data about companies
that we have existing dealings with. The data in Table2 is imported from
another database (supplied by a 3rd party). We need a way to know that, if we
are looking at the data in table 2, any company that may be linked to the
company in table 1 is highlighted. (they may belong to the same parent
company e.g. ABC North, ABC South both have parent company ABC UK)

 

[Damon Heron]

Okay, then it is not feasible to amend the table. So, look into a query -
SELECT Table2.*
FROM Table2
WHERE (((Table2.CompanyName) Like "ABC*"));

Damon