slayden@msn.com

Auto complete for choosing a Contact ID from large table

Discussion created by slayden@msn.com 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?

 

Thanks

Scott

Outcomes