Ariel, >question: is there paging in the autocomplete program for AJAX based option >queries?
You can have the AJAX operations return whatever you want. If you want it to just return a subset of matches, then make sure to turn the Autocomplete caching mechanism off--that way each lookup will query the database again. Personally, if I'm looking up against a really large recordset, I'll just require a minimum of 3 characters before I do the lookup. That usually reduces the recordset to a small enough number, that I then send all the data and let it be cached locally so there are no more AJAX operations. -Dan