This tutorial shows how to create a grid with the search function on the same page.
Creating a new grid
1. Create a new grid application using the product table.
2. Choose the Field positioning option in the application menu and choose ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice and UnitsInStock.
Change the settings to display the grid and search on the same page
3. Return to the initial “Grid Module” options
4. In INITIAL MODULE select Search.
5. In APPLICATION MODULES Set Yes to Use Iframe.
Search field settings
6. Open the search folder and click “Advanced search >> Select fields“.
7. Choose the SupplierID and CategoryID fields.
8. Click in the SupplierID field.
9. Set the Data Type property to Select.
10. Open the Search Lookup block.
11. Define the settings according to the image below.
12. Enable the OnChange option in the Field Behavior block. With this option enabled, the search is automatically executed when an option is changed.
13. Open the CategoryID field settings, change the Data Type property to Select and make the following changes.
14. Open the Field Behavior block and configure it according to the image below.
15. Click the Run button on the toolbar.