Still looking for HELP... identify identical company names.

[Guest]

I have posted twice looking for a way to solve a problem, with suggestions
but no real direct solution.

I have an access 2000 DB with sales leads, I have a form based on a search
query by state and have merged information on duplicate information to
normalize my database. The issue I am attempting to solve is that some
companies have multiple locations (same company name, different addresses,
phone ect...) since these stores may be franchises or purchase products
independently there is no relationship other than company name and they need
independent records.

What I need to do is have some type of alert that will indicate there are
identical company names in the query and show the user the primary key
numbers (pkcompanyid), of each matching record by company name, I am
thinking a subform will accomplish this but am not sure how to code it in.

Any Help will be greatly appreciated.

 

[Guest]

Why not add a field to describe the company-location --
Franchise
Distributor
Independent

 

[Guest]

Already have a field which describes catagory (ie. Chain, Single Location,
etc..) Even if the store is listed as a chain they may or maynot purchase
product independently (local purchase option). Thus each distinct address
location is its own record.

Any suggestions?