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 List Tutorial), the key is "SubjectID":

Discussion

previousnext
 
expand all collapse all