Hi,

I’m looking for an example protocol that shows an autocompleting text box that searches a database as someone is typing. I hoping someone might have something similar they could share.

e.g - as someone is typing CP-001234  it might suggest CP-00012345678-00 by running a query in the background "select x where compound like ‘%y%’;  " and returing the results.

The returned suggestion(s) could be in the same text box (perhaps as a drop down of options) or maybe a combination of a text box and a list box (e.g user starts typing in the text box and the list box populates). In the end the user selection(s) would be passed onto another protocol

I currently do this with a (Fast)Searchable list box which can handle 100,000s of rows, but it takes too long to populate these initially as you move into millions of rows (which I’d like to)...

I guess the approach would be to use a dynamic AJAX report linking to a protocol that runs the SQL statement. However I know there are often many different approaches. Does anyone have an example to hand of something similar they would be willing to share? 

All the examples I’ve been able to find deal more with charts / images etc and I’ve not much (any) experience with AJAX

Thanks

Joe