AnsweredAssumed Answered

What is the most efficient way to find 1 name out of thousands for a record?

Question asked by weedonpaul on Nov 2, 2015
Latest reply on Nov 2, 2015 by siplus

I have a layout called contacts that links to a table called contacts there is an other table called companies that has a relationship with contacts. When entering a new contact into the layout, I currently search through the list of companies to find on that exists or create a new one. I do this with a drop down list that lists company ID's but displays their names. However this is a pain in the arse as there are thousands of company names.

 

I did try auto complete but that just tries to create a duplicate record in companies

 

Is there a better way to do this?

Outcomes