Textbox with dropdown
Textbox with dropdown in its initial state. It looks similar to a regular dropdown box.
But when clicked, it does not open up the dropdown list.
Instead, it lets the user type as in a normal textbox.
It's only when the user clicks the down-arrow that the list opens. The user can pick an item in the list, or type something else.
SQL-statement that fills the dropdown-control with possible values.
Retrieves the default value for the control.
This call is only made if there is a field validation set for the field info and the field has any content.
Performs field validation when the user leaves the field or one of its dependencies is changed, initial values set by default value and initial values in edit-mode are not validated.
When saving the validation runs server side if the field value has changed. A field value is considered changed if in new mode the value is anything other than
NULL. In edit mode it is considered changed if it has a value that was not returned by the GetEditFields procedure.
The name depends on the usage. If the control is used to retrieve values from a lookup table then the procedure should be named "<Schema>.<LookupTable>TextboxWithDropdown". If it is not and the values are not directly linked to rows in a table (say for instance you want to retrieve previously used values) then the procedure should be named "<Schema>.<Table><Field>_TextboxWithDropdown".