AnsweredAssumed Answered

Best performing way to select records from a table

Question asked by smith7180 on Jan 20, 2015
Latest reply on Jan 21, 2015 by smith7180

Say you're on a transaction record and you want to allow the user to select from all contacts.  Most methods I've seen involve a filtered portal:  the user types some letters in a field (ex. 'ja') and the portal that displayed all contacts now filters to only matching ( ex. jack, jane, Janice, etc...)  I see now that this is a slow method that pulls way more data than I need.

 

Can someone point me in the direction of discussions/tutorials of more efficient ways to do this?  I don't want to ask anyone to do my work/research for me- just looking for some pointers.  I've been putting off learning sql for to long now and am wondering if perhaps it would offer me a quicker solution to this problem.

 

Thanks.

Outcomes