Organizer Advantage is powerful yet easy to use database manager for Windows.
Advantage Designer lets you modify our solutions or easily create new ones.
Take control of your data with our simple or buinsess database software solutions.


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


easy-to-use database designer

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
text field type, combo box control type

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).
text field type, combo box control type, sql list
text field type, combo box control type, define sql list
text field type, combo box control type, list source table
text field type, combo box control type, sql list, loaned to

 

Copyright © 2021 · All Rights Reserved · PrimaSoft PC