Access A Specific Item In DB in my for statement

I have a somewhat odd scenario. I am using a read only database that i have access through my property management software. They allow the user to define fields in there software. However they dont show up as specific fields in the database. The database has 2 tables related to them "propuserdefined" and "propuserdefinedvalues". The "propuserdefined" contains all the info about the field(id, name, description) the "propuserdiefinedvalues" contains the values associated with the property. It has propid, userdefinedid, and value. My question is this, I need to access the value of "propuserdefinedvalues" where propid equals the propid in my for property in properties statement and the "userdefinedid" equals 49. How would i do this? Is it with a template tag?

Thanks in advance for your help. 

Brandon

Here are my models.

class Propuserdefined(models.Model):      userdefinedid = models.IntegerField(primary_key=True)      name = models.CharField(max_length=50L, blank=True)      type = models.IntegerField()      userid = models.IntegerField(null=True, blank=True)      updated = models.DateTimeField(null=True, blank=True)      datecreated = models.DateTimeField(null=True, blank=True)      combolist = models.TextField(blank=True)      class Meta:          db_table = 'propuserdefined'    class Propuserdefinedvalues(models.Model):      userdefinedid = models.IntegerField()      propid = models.IntegerField()      value = models.TextField(blank=True)      userid = models.IntegerField(null=True, blank=True)      updated = models.DateTimeField(null=True, blank=True)      datecreated = models.DateTimeField(null=True, blank=True)      class Meta:          db_table = 'propuserdefinedvalues'    class Property(models.Model):      propid = models.IntegerField(primary_key=True)      name = models.CharField(max_length=35L, blank=True)      shortname = models.CharField(max_length=6L, blank=True)      street1 = models.CharField(max_length=50L, blank=True)      street2 = models.CharField(max_length=50L, blank=True)      city = models.CharField(max_length=50L, blank=True)      state = models.CharField(max_length=2L, blank=True)      zip = models.CharField(max_length=50L, blank=True)      phone = models.CharField(max_length=21L, blank=True)      fax = models.CharField(max_length=50L, blank=True)      email = models.CharField(max_length=255L, blank=True)      manager = models.CharField(max_length=25L, blank=True)      billname1 = models.CharField(max_length=35L, blank=True)      billname2 = models.CharField(max_length=35L, blank=True)      billstreet1 = models.CharField(max_length=50L, blank=True)      billstreet2 = models.CharField(max_length=50L, blank=True)      billcity = models.CharField(max_length=50L, blank=True)      billstate = models.CharField(max_length=2L, blank=True)      billzip = models.CharField(max_length=50L, blank=True)      proptaxid = models.CharField(max_length=35L, blank=True)      rentchargetype = models.CharField(max_length=20L, blank=True)      lastpostdate = models.DateField(null=True, blank=True)      lastweeklypostdate = models.DateField(null=True, blank=True)      comments = models.CharField(max_length=25L, blank=True)      enablespeciallatecharge = models.IntegerField(null=True, blank=True)      fixedlatecharge = models.IntegerField(null=True, blank=True)      fixedlateamount = models.FloatField(null=True, blank=True)      fixedlaterentonly = models.IntegerField(null=True, blank=True)      percentlate = models.IntegerField(null=True, blank=True)      percentlateamount = models.FloatField(null=True, blank=True)      percentlatefullcharge = models.IntegerField(null=True, blank=True)      percentlaterentonly = models.IntegerField(null=True, blank=True)      perdaylate = models.IntegerField(null=True, blank=True)      perdaylateamount = models.FloatField(null=True, blank=True)      perdaylategrace = models.IntegerField(null=True, blank=True)      perdaylategracenum = models.IntegerField(null=True, blank=True)      perdatelatelimitamount = models.FloatField()      perdaylategracenonretro = models.IntegerField()      perdaylategraceexclweekends = models.IntegerField()      perdaylategraceexclholidays = models.IntegerField()      datecreated = models.DateTimeField(null=True, blank=True)      updated = models.DateTimeField(null=True, blank=True)      userid = models.IntegerField(null=True, blank=True)      logofile = models.CharField(max_length=255L, blank=True)      merchantid = models.CharField(max_length=255L, blank=True)      epaybankid = models.IntegerField()      epaylimit = models.FloatField()      epayenabled = models.IntegerField()      achconveniencefeeenabled = models.IntegerField()      ccconveniencefeeenabled = models.IntegerField()      rwaachconvenciencefeeenabled = models.IntegerField()      rwaccconveniencefeeenabled = models.IntegerField()      epayislimited = models.IntegerField()      epayusedefaults = models.IntegerField()      achconveniencefee = models.FloatField(null=True, blank=True)      ccconveniencefee = models.FloatField(null=True, blank=True)      rwaachconveniencefee = models.FloatField(null=True, blank=True)      rwaccconveniencefee = models.FloatField(null=True, blank=True)      epaychargetype = models.IntegerField()      epayamounttype = models.IntegerField()      epaysetamount = models.FloatField()      epaycustlimit = models.FloatField()      sqft = models.IntegerField()      lateminbalance = models.FloatField(null=True, blank=True)      defaultbank = models.IntegerField()      postday = models.IntegerField(null=True, blank=True)      active = models.IntegerField(null=True, blank=True)      iscommercial = models.IntegerField(null=True, blank=True)      assignedissueuserid = models.IntegerField(null=True, blank=True)      altname = Propuserdefinedvalues.objects.filter(userdefinedid=49)      class Meta:          db_table = 'property'

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.