Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Forms > Form Designer > Form Controls > Variable Controls > Variable Lookup List Box

Lookup Settings

Scroll Prev Top Next More

 

ð Lookup Table/View and Field

 

List Source

Table Name

Specifies the lookup table that the values are derived from

Key Field

Specifies the column that the values are derived from the Source Table, which will be inserted into the destination table as the return column

 

Single-Column

Specifies the layout of the values in a single column format

Multi-Column

Specifies the layout of the values in a multi column format

Distinct Value(s)

Limits the data values to omit duplicates

Load List Box with values from Column / Columns Chosen:

Specifies the column(s) from the List Source Table to display in the Lookup List Box to select from. A button is available to allow editing using the R:BASE Editor.

 

ð WHERE Clause

Specifies the WHERE Clause syntax to qualify or restrict the displayed results. A button is available to allow editing using the R:BASE Editor.

Copy Lookup SQL Statement to Clipboard

The button will copy the specified SQL statement to the clipboard to be tested at the R> Prompt or in a command file

Where Builder

Opens the Where Builder dialog for a graphic interface to create the WHERE Clause

 

ð Color Rows

Row Background Color Field

Use this option to specify the column name assigned to store the background color for the row

Row Font Color Field

Use this option to specify the column name assigned to store the font color for the row

VarLookupListBox_LookupSettings