Auto complete for choosing a Contact ID from large table

Discussion created by on Dec 17, 2013
Latest reply on Dec 17, 2013 by keywords

I have

  1. > 10,000 contacts in a contacts table


I use the following tables

  1. transactions
  2. contacts
  3. trans_con_joinRole, which contains transID, Con ID, transRole


I have a MASSIVE dropdown list (users are complaining) to attach a contactID (show contactName, but use contactID) to a transaction via the join table


How can I use autocomplete to efficiently locate the contact and put their ID into the join table?