Button lookup

Parent Previous Next

Button Lookup Object Properties



A lookup button allows to automatically perform a database lookup and return the selected record to the validation screen.



Icon

Select from the available icons the icon to use on the lookup button.

The icons are located in the Icon folder on the application installation folder.


Text

Label to show on the button.


Dialog title

Label to show as title on the lookup dialog.


Left

Left position of the top left corner of the object.


Top

Top position of the top left corner of the object.


Width

Width of the object.


Height

Height of the object.


Lookup type

Select the lookup type to use for this button, available options are:


Shortcut

Select a shortcut to directly put focus on a field.

Default value: None





When Locator is used, the following settings can be configured:



Source

Select from the list of defined database locators the locator to use.


Mapping

Select from the list of columns defined in the database locator the fields to use for lookup.


Visibility

Select from the list of columns the fields to show in the lookup selection dialog.



When Local database is used, the following settings can be configured:



Source

Select from the list of defined local databases the database to use.


Mapping

Select from the list of columns defined in the database the fields to use for lookup.


Visibility

Select from the list of columns the fields to show in the lookup selection dialog.



When Relational database is used, the following settings can be configured:



Source

Select from the list of defined relational databases the database to use.


Mapping

Select from the list of columns defined in the database the fields to use for lookup.


Visibility

Select from the list of columns the fields to show in the lookup selection dialog.



When Validation rule is used, the following settings can be configured: 



Source

Select from the list of defined database validation rules the rule to use.