|  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 

Designer Help > Data Fields, Controls > Text > Text Combo Box

Text / Combo-Box

Combo-Box (Drop-Down List) is a data entry control that combines an edit box with a list. You can either type text into the edit box or select an item from the list. The list items can be edited in the Edit List Items window. The Drop-Down List data entry control has the following Popup Menu functions: Edit List

If you want to use a Combo Box in your table:

• Create Text field type
• Select Combo Box Field in the Select Control Type window

There are 3 list types

• A: Auto-Add; this is the most common used type; predefined list items you can create in the Edit List Items window; new values are added automatically to the list during data entry.
• E: Editable; predefined list items you can create in the Edit List Items window; if a new value is entered into the edit box this item is not added to the list for the future use.
• L: Locked; list items can be set only by editing the list file manually or by editing the list source table (List SQL Type option).

The List SQL option lets you use A, E, L types.

How to predefine list items for the Locked type?

If the table name is TABLE_NAME and the field name is LIST_NAME then the program creates a file with the name TABLE_NAME.LIST_NAME.LST ; open this file in the Windows Notepad application and type in your list box values, one per line.

How to use List SQL?

• Create Text field type (in this example we created LOANEDTO in the BOOKCATALOG table).
• Select Combo Box Field in the Select Control Type window (in this example, on the form we selected Combo-Box for the LOANEDTO).
• Link the field with the field from another table (in this example, we linked the LOANEDTO with student names from the BORROWERS table, define list values with the SQL statement).

How to use List SQL?

Music Collection, simple field linking (how to link the list box with the field from another table).

Organizer Advantage, Simple Database Solutions for Windows PC

Organizer Advantage, Business Database Solutions for Windows PC

Organizer Advantage Free Service

Organizer Advantage Support