Every item in a list has a key value that uniquely identifies the item. It could be a basic auto-incremented integer or a number or string uniquely assigned to the list items.
When creating a list, choose the:
- Primary Key, the name of the column that holds the unique key. If data imported to the list does not already include a column by this name, it will be added. Default: "Key".
- Primary Key Type:
- Auto-Increment Integer (Default)
- Integer
- Text (String)
Once your list has been created, the field that holds the key is marked by a key in the list design editor. In the example list below (NIMHDemographics, from the
Tutorial: Lists), the key is "SubjectID":