Adding items to the grid

To map a column from the query result set of a data source connection to a GainSeeker Field:

1. Determine which data source connection contains the column you want to map.  Then select this connection from the drop-down list.
   
   
   
   To view the first few rows of the query result set for this connection, click Execute Query.

2. Drag an item from the list of columns and drop it into the appropriate cell of the grid.
   
    
   
   Alternately, you can click an item in the list of columns, right-click in the appropriate cell of the grid, and click Add Selected Item.
   
   
   
   A third option is to right-click in the appropriate cell of the grid, point to Add, and select the desired item from the list.
   
   

After an item has been added to the grid, the list of columns displays an asterisk beside the item (except for Static Text and TODO).  One item can be added to multiple cells in the grid or not used at all.

You can map items from multiple connections into the grid, as shown in the example below:

If you have many items to map, you may want to make the grid larger by clicking the magnifying glass or by right-clicking on the grid and selecting Maximize.