JavaScript Editor js editor     Web development 



Main Page

File: ...\Samples\Solution\Forms\Datalook.scx

This sample illustrates providing users with a set of values, selected from another table, in a list box and in a combo box. The value the user chooses is stored in the current table.

It is often more convenient for a user to choose from a list of predetermined values, and, of course, you minimize the risk that the user will mistype a value. Setting a few list box properties is all that is required to provide this capability. For example, the following properties were set for cboEmp_id on the Using Combo Box page:

Property Setting

BoundColumn

2

ColumnCount

2

ControlSource

orders.emp_id

RowSource

SELECT DISTINCT ALLTRIM( employee.first_name) + " " + ALLTRIM( employee.last_name) , EMP_ID FROM employee INTO CURSOR cEmpCombo ORDER BY first_name

RowSourceType

3 – SQL Statement

Rather than having the user choose an employee id number from the drop-down list, the SELECT statement makes it possible for you to show the user the employees' first and last names.

Because the SELECT statement creates a cursor, code in the Destroy event closes the cursor.

В Copy Code
IF USED("cEmpCombo") THEN
   USE IN cEmpCombo
ENDIF

See Also



JavaScript Editor js editor     Web development