matching company name indicator

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sales databse which has a form based on a query that user looks up
companies in a particular state they wish to call. I would like to have some
kind of indicator or alarm if there is an exact match of the Company name
field to any other records in the query. I was thinking a subform which
would list the ID number of those records which match the company name of the
current record.

Any suggestions on how I can make this happen would be a big help.

Barry
 
Barry,

I would suggest normalizing your company names out to a companies table,
with a relationship to the calls table. On your form, you could set the
companies combobox to LimitToList = No and add code to the NotInList event to
add new companies to the companies table. You'd now have a master/detail
records situation that would lend itself well to a parent/subform.

HTH,
Barry
 
Barry,

Thanks for the suggestion, the problem is not adding new companies but
having an indicator when there may be multiple locations that we are not
aware of off hand.

This is why I need the alert to idintical company names in the query/form, I
have made unique records for each distinct record however some stores have
several locations with differnet addresses etc.. since there may be identical
company names in different states a normilized company table will not work as
the companys from different states may not be connected in any manner.

Thanks for your input, still looking for a way to alert users if there is an
exact match of company names.

Barry
 
Back
Top