Autocomplete

In this tutorial, you will see how to use a field of type AutoComplete.

Creating a Form application.

1. Create a  “Form” application  and select the “Single Record” option   , then select the “Orders” sample table  .

2. Still in the application creation window, if you want a better display of the Form, select the “Fields” tab and change the Label of the fields, as shown below:

Editing Form Fields

1. In the application menu, select the “Field Positioning” item .

2. Select the fields: OrderID, CustomerID, OrderDate, RequiredDate and ShippedDate.

3. In the application menu, access the “Fields” tab and select the “CustomerID” field .

4. Within the field settings, change the “Data Type” property to “Auto-Complete Text” .

5. Still in the CustomerID field, access the “Lookup settings” editing guide .

6. In the SQL Command property, insert the code below:

SELECT CustomerID, CompanyName 
FROM customers 
ORDER BY CustomerID

7. Enable the properties “Show label with description” and “Capture Text” . Then, in the “Label” property, enter “Search” .

8.  Finally, select the  “Run Application” button  on the toolbar to generate the Form.

Tutorials in the same category

Responsive login form 3

To learn how to use the templates available within the ScriptCase in the security module, follo...

Responsive login form 2

To learn how to use the templates available within the ScriptCase in the security module, follo...

Responsive login form

To learn how to use the templates available within the ScriptCase in the security module, follo...

Summary With Fixed Label

A report in summary format with labels anchored to the top of the screen. Creating the Grid ...

Comment this post