Columns
TeamDesk tables are divided into columns. Every column contains a value of a specific attribute of a table record, for example, First Name, Last Name, Company and so on:
In the Setup mode Columns
are listed on the Columns form, where a user can add New
columns, create New Reference columns, Lookup Columns, Summary Columns. Also a user can Edit
or Delete
existing columns, set Key Columns and specify Columns Access rights.
To go to the Columns
form, click Setup
link at the top right corner of the window.
Select a table you need.
From the setup menu select Columns
> Customize existing columns
. The system will display a list of columns comprised in a table.
Table column list is grouped by type and sorted in alphabetic order.
Firstly, you can see all updatable columns:
Next, formula columns are displayed with formula preview:
Then, relations including reference columns and corresponding lookup columns are listed:
Next go all selections/details with all summary columns and recordset columns:
And at last all system columns are displayed: