title: Link one table to another?
body: <p>i'm trying to set up some tables in my SQL Express server, and i want to do something to the effect of this:</p>
  
  <pre><code>create table programs (
      progid int primary key identity(1,1),
      name nvarchar(255),
      description nvarchar(500),
      iconFile nvarchar(255),
      installScript nvarchar(255)
  )
  </code></pre>
  
  <p>however i want each "program" to have a set of categories associated with it, what's the best way to do this? i read somewhere that it's not a good idea to store multiple items under a single category entry.</p>