I'm trying to clean up a list that I inherited from a coworker and I'm assuming a "List" on SharePoint is the same as an Access table/db. Please correct me if I'm wrong.

This list does not have a column/field that is unique to each record. I would like to add a column/field that would be applied to the existing records and be autopopulated to any new records created. If I select 'add a column', these are the types I can choose from:
  • Single line of text
  • Multiple lines of text
  • Choice (menu to choose from)
  • Number (1, 1.0, 100)
  • Currency ($, ¥, €)
  • Date and Time
  • Lookup (information already on this site)
  • Yes/No (check box)
  • Person or Group
  • Hyperlink or Picture
  • Calculated (calculation based on other columns)
  • External Data
  • [company] Global Lookup Field Type
  • [company] Taxonomy Field Type
  • Business Unit Lookup
  • Category Lookup
  • [company] Common Field Type (Subject to retirement)
  • Company Lookup
  • Data Classification Lookup
  • Department Lookup
  • File Type Lookup
  • Language Lookup
  • Region Lookup
  • Managed Metadata


I believe the site is running on SharePoint Server 2010. If there's any other information you require in order to help, please tell me and I will find it.

Thanks.