image104


ð User can Access a Pop-up Menu
 
Enables the user to acess a pop-up menu when the field is double-clicked. By default, this will return all the values in the table for the associated column  
 
 
ð Automatic Pop-up
 
Pop-up menu is automatically presented when the focus is shifted to the object  
 

ð Use a Custom Pop-up
 
Pop-up menu can be custom designed to return lookup values from other tables/views, and display optional Dynamic Where Clauses  
 
 
ð Skip to Next Field After Pop-up
 
Focus is automatically shifted to the next object in the tab order when the pop-up menu is closed  
 
 
ð Table/View Name

Specifies the table/view that the menu values will be retrieved from  
 
 
ð Pop-Up Type

Specifies the type of pop-up menu: Single Column; Multi Column; Expression; Expression with Column  
 
 
ð Column Returned

Specifies the column from the table/view for the data source  
 
 
ð Menu Values

If you selected Expression from the Pop-Up Type, enter the expression in this field  
 
 
ð Menu Caption

Caption value which the pop-up menu will display when visible  
 
 
ð Menu Title

Title value which the pop-up menu will display when visible  
 
 
ð Number of Lines

Limits the number of values displayed in the Pop-up Menu  
 
 
ð Show Lines

Displayed lines between the values in the Pop-up Menu  
 
 
ð Distinct Values

Displayed distict values in the Pop-up Menu  
 
 
ð Title Font

Specifies the font style, size and color for the title  
 

ð List Font

Specifies the font style, size and color for the values in the list  
 
 
ð Title Background Color

Specifies the background color of the title  
 

ð List Background Color

Specifies the background color of the values in the list  
 
 
ð WHERE Clause

Use Dynamic Where Clause  
Prompts the user for data input to filter the returned data that is displayed  
 
Message  
This value displays as a title to the Where Clause input window when using a Dynamic Where Clause  
 
Where Builder  
Opens the Where Builder dialog for a GUI interface to create your expression