Define Keys
A "column" is a field in a database. In the Define Keys screen you will choose the key of your primary table.
Unique Key for Updates. Here you choose a unique key for updates to the database. Some databases, such as MS-SQL Server, will automatically show the unique key. If not, you must select the unique key(s) for updates.
It is important that you use the same key for Data components that you later wish to create Interactions between. Even if the tables in one component are different from those in another you should still define the same key for each. For example you may choose stor_id from the stores table in your Result List component and then you would choose stor_id, ord_num form the sales table when creating your Detail Grid. In this way the Result List will pass the stor_id to the Detail Grid telling it to load all the matching rows for this store.
Column Definition. The fields on the right of the screen are there to display the details about a particular column. Double-click a column to reveal its details. These fields are not editable.