- > 10,000 contacts in a contacts table
I use the following tables
- 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?