title: SQL Server: How to allow duplicate records on small table
body: <p>I have a small table "<code>ImgViews</code>" that only contains two columns, an ID column called "<code>imgID</code>" + a count column called "<code>viewed</code>", both set up as int. </p>
  
  <p>The idea is to use this table only as a counter so that I can track how often an image with a certain ID is viewed / clicked. </p>
  
  <p>The table has no primary or foreign keys and no relationships. 
  However, when I enter some data for testing and try entering the same imgID multiple times it always appears greyed out and with a red error icon. </p>
  
  <p>Usually this makes sense as you don't want duplicate records but as the purpose is different here it does make sense for me. </p>
  
  <p>Can someone tell me how I can achieve this or work around it ? What would be a common way to do this ?</p>
  
  <p>Many thanks in advance, Tim. </p>