I have a foreign key linking two models. One is called ZumaDirectors, the other ZumaConsolidated. For some reason I cannot access fields on ZumaConsolidated from ZumaDirectors using foreign key. I can do this without a problem on ZumaDirectors with a foreign key linked to another table.
I want to be able to do eg. p=ZumaDirectors.all_directors_key.company_name
but when I try this I get this error: "Attribute error: long object has no attribute 'company_name'. The same error applies for any field I try and access.
Here are the models. I am tearing my hair out and would be glad for any help.

class ZumaConsolidated(models.Model):
    id = models.IntegerField(primary_key=True, db_column='id')
    id_no = models.TextField(blank=True)
    zuma_details_first_name = models.TextField(db_column='Zuma_details_First_name', blank=True) # Field name made lowercase.
    zuma_details_surname = models.TextField(db_column='Zuma_details_Surname', blank=True) # Field name made lowercase.
    first_name = models.TextField(blank=True)
    surname = models.TextField(blank=True)
    type = models.TextField(blank=True)
    status = models.TextField(blank=True)
    doa = models.DateField(db_column='DOA', blank=True) # Field name made lowercase.
    company_name = models.TextField(db_column='Company_name', blank=True) # Field name made lowercase.
    registration_number = models.TextField(db_column='Registration_number', blank=True) # Field name made lowercase.
    registration_date = models.DateField(db_column='Registration_Date', blank=True) # Field name made lowercase.
    company_status = models.TextField(db_column='Company_status', blank=True) # Field name made lowercase.
    registered_address = models.TextField(db_column='Registered_address', blank=True) # Field name made lowercase.

    def __unicode__(self):
        return ('%s %s %s') % (self.zuma_details_first_name, self.zuma_details_surname, self.company_name)


    class Meta:
        db_table = u'zuma_consolidated'

class ZumaDirectors(models.Model):
    all_directors_key = models.ForeignKey(ZumaConsolidated, db_column='All_directors_key') # Field name made lowercase.
    companies = models.ForeignKey(ZumaCompanies, null=True, db_column='companies', blank=True)
    first_name = models.TextField(blank=True)
    surname = models.TextField(blank=True)
    type = models.TextField(blank=True)
    status = models.TextField(blank=True)
    doa = models.DateField(db_column='DOA', blank=True) # Field name made lowercase.

    def __unicode__(self):
        return ('%s %s') % (self.first_name, self.surname)

    
    class Meta:
        db_table = u'zuma_directors'
This article has been dead for over six months. Start a new discussion instead.