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?