Setting the Key Column
Imagine your database tracks spare parts stored in a warehouse. Every spare part has its own inventory number that is unique. So you may identify a spare part using the inventory number. In that case the Inventory number column is the Key column that identifies spare part records.
The key column is a column containing values that identify all records in the table. For example, if the
ID column is a key column for the
Users table, all user records will be identified by their IDs.
To set the key column:
Setup link at the top right corner of the window.
Select a table you need.
From the setup menu select
Columns > Set the key column. The system will display the
Key Column form:
Select a necessary value from the list in the
Key Column field.
Save button to save the changes.
The data in the key column should unambiguously identify a table record. When a new table is created, the TeamDesk system creates a special
AutoNumbercolumn used for data identification. If necessary, this column may be renamed (for example, into
When the key column is changed, TeamDesk tries to make a new column
Unique so that every table record can have its own unique value in the key column. In case of a failure the following errors can occur:
Can not make column 'name' required.
Can not make column 'name' unique.
If a table uses relationships, the system performs the following succession of actions:
A new reference column is created in the detail table. The column is populated with new keys using an old key - reference pair to search for correspondences. Note that not all table cells may be populated - some values may be missing.
An old reference column is deleted and all non-found values will be permanently lost at that.
Lookupcolumn connected with an old key column is created instead of an old reference column.