title: getting database values using get_object_or_404
body: <p>I am using <code>get_object_or_404</code> to try to get a list of values from my database. I'm trying to filter the <code>get_object_or_404</code> function for the state variable to grab only values that are associated with the <code>disease_id</code>. The code below does not work (it grabs all values in the State table. Any ideas?</p>
  
  <p><em>views.py</em></p>
  
  <pre><code>def option(request, disease_id, state_id):
  
      state = get_object_or_404(State, relevantdisease=disease_id)
      disease = get_object_or_404(Disease, pk=disease_id)
  
      context = {'state': state, 'disease':disease }
      return render(request, "option.html", context)
  </code></pre>
  
  <p><em>models.py</em></p>
  
  <pre><code>class State(models.Model):
      state = models.CharField(max_length=300, verbose_name='state')
      relevantdisease = models.ForeignKey(Disease, verbose_name="disease")
  </code></pre>