a

Capture information from a grid

This example demonstrates a very useful feature to obtain information relative to a grid field from an extern list during a grid record update. Here two applications are created (a grid and a form). In the form application a capture link pointing to the grid is created.

Creating the Grid application.

1. Create a new grid application based on the table categories.

2. In the application menu open the folder Grid and click in Settings.

   

3. Change the Pagination attribute to Total. This option hides all the navigation buttons on the Grid.

   

4. In the application menu click in the item Select Fields.

   

5. Select only the fields CategoryID and CategoryName.

   

6. Click in Toolbar from the Grid folder

   

7. Remove all the buttons from the Bottom toolbar and leave only the button Exit on the Top toolbar.

   

8. Generate the grid source code by clicking in Generate Source in the ScriptCase toolbar.

   

 

Creating the Form application.

9. Create a new Simple form application based on the table products.

   

10. Select the New Link option on the Links folder.

   

11. Click in Create New Link, select the link type Capture and the field CategoryID. Click in Next.

   

12. Select the grid application created above (item 1). Continue until complete the link creation according to the wizard directions.

Untitled Document

Rate this Tutorial
Bad Great
Leave your comments (optional).