Vencor Software

A lookup type-ahead field handler comes with StudioWorks. The field handler mimics the behavior of Outlook Express when entering an email address. If multiple matching records are found the type-ahead handler defaults to the record last selected by the user. After the user selects the record the field handler automatically sets the foreign key value to the referenced column in the lookup records list.

The lookup type-ahead code is completely generic and works with schemas or query classes. The lookup type-ahead field handler even works on complex grids!

Lookup fields can be set to wait until the 2nd, 3rd, 4th... character before beginning to searching for matching records.

Lookup fields can be set to search for 'begins with' or 'contains' the text which the user has typed.

The lookup droplist results are limited to 50 records, if more records are available a 'More Records' button appears in the droplist. The user can click the 'More Records' button to fetch the next batch(es) of matching records.

If a matching record is not found when the user leaves the lookup field, the user will be prompted to Select, Cancel, or Setup a lookup record. The Setup option is only available to users who have permission to insert records into the lookup table.