Auto-complete for reference fields By default, a reference field auto-completes as the user types in the field. Administrators can configure additional auto-complete options. A user must have table-level read permission on the referenced table for auto-complete to display any options. Figure 1. Auto complete Dictionary attributes for auto-completion of reference fieldsThere are dictionary attributes that are specific to reference fields and that determine auto-complete behavior. Auto-complete UI featuresUI FeaturesDefine auto-complete attributes for all references to a tableA field inherits and uses the reference table's auto-complete attributes unless the field has its own value for the same attributes. You can define the attributes for references to a table, and it affects every form that references that table.Remove the display value columnYou can remove the display value column from a reference field by setting the ref_ac_display_value attribute to false.Improve auto-complete queriesBy default, all reference fields use a starts with query to search for matching text in the reference table. This prevents auto-complete from executing inefficient contains queries every time a user searches a reference field. You can require all reference fields to use a starts with query.Configure auto-complete to match text from any reference fieldBy default, auto-complete only matches text in the display value column. You can configure a reference field to match text from any additional column the reference field displays.Display a reference field as a choice list You can display a reference field as a choice list instead of opening a lookup window.Enable contains auto-complete searchesBy default, the reference auto-complete uses a starts with search. A user preference can be created to implement a contains search.Wildcards in reference auto-completesWildcard searches use the auto-complete functionality.