Thank you Kai, I really appreciate the time you put in to help me with that, it had me puzzled because all this time I was looking for something wrong with my fixture or result classes when it fact it had nothing to do with them, it was due to my last class called SquadSelector as shown below:
class SquadSelector(models.Model): fixture = models.ForeignKey(Fixture, "Fixture", core=True, help_text="Fixture to select squad for.") gk = models.ForeignKey(Player, "Goal Keeper", related_name="gk", core=True, help_text="Name of Goal Keeper.") rb = models.ForeignKey(Player, "Right Back", related_name="rb", core=True, help_text="Name of Right Back.") cb1 = models.ForeignKey(Player, "Centre Back", related_name="cb1", core=True, help_text="Name of First Centre Back.") cb2 = models.ForeignKey(Player, "Centre Back", related_name="cb2", core=True, help_text="Name of Second Centre Back.") lb = models.ForeignKey(Player, "Left Back", related_name="lb", core=True, help_text="Name of Left Back.") rw = models.ForeignKey(Player, "Right Wing", related_name="rw", core=True, help_text="Name of Right Winger.") cm1 = models.ForeignKey(Player, "Centre Midfield", related_name="cm1", core=True, help_text="Name of First Centre Midfielder.") cm2 = models.ForeignKey(Player, "Centre Midfield", related_name="cm2", core=True, help_text="Name of Second Centre Midfielder.") lw = models.ForeignKey(Player, "Left Wing", related_name="lw", core=True, help_text="Name of Left Winger.") cf1 = models.ForeignKey(Player, "Centre Forward", related_name="cf1", core=True, help_text="Name of First Centre Forward.") cf2 = models.ForeignKey(Player, "Left Forward", related_name="cf2", core=True, help_text="Name of Second Centre Forward.") sub1 = models.ForeignKey(Player, "1st Sub", related_name="sub1", help_text="Name of 1st Sub.") sub2 = models.ForeignKey(Player, "2nd Sub", related_name="sub2", help_text="Name of 2nd Sub.") sub3 = models.ForeignKey(Player, "3rd Sub", related_name="sub3", help_text="Name of 3rd Sub.") sub4 = models.ForeignKey(Player, "4th Sub", related_name="sub4", help_text="Name of 4th Sub.") sub5 = models.ForeignKey(Player, "5th Sub", related_name="sub5", help_text="Name of 5th Sub.") class Admin: pass list_display = ('fixture', ) list_filter = ['fixture',] search_fields = ['fixture'] # -------- # Accessor # -------- #String method def __str__ (self): return str(self.gk) >From the line: fixture = models.ForeignKey(Fixture, "Fixture", core=True, help_text="Fixture to select squad for.") the bit "Fixture" which I have on all my fields because I thought it is a verbose name, which you cannot apparantly specify for a foreign key (I assume it gets it from the other table?) So it was looking for a field called Fixture in the table Fixture, which there was not and giving me the error: raise FieldDoesNotExist, '%s has no field named %r' % (self.object_name, name) django.db.models.fields.FieldDoesNotExist: Fixture has no field named 'Fixture' Which made me look at my fixture class when indeed it wasn't the place the error was occuring. Thanks again, DuncanM On Mar 5, 12:07 am, "Kai Kuehne" <[EMAIL PROTECTED]> wrote: > Hi Duncan, > > this works for me: > > from django.db import models > > class Fixture(models.Model): > #team = models.ForeignKey(Team, "Team", core=True) > #venue = models.CharField("Venue", maxlength=1, > choices=Fixture_Choices, core=True) > date = models.DateField("Date", core=True) > opponent = models.CharField("Opponent", maxlength=100, core=True) > kickoff = models.TimeField("Kick Off Time") > #competition = models.ForeignKey(Competition, "Competition", core=True) > > class Admin: > #list_display = ('date', 'team', 'opponent', 'venue', > 'kickoff', 'competition') > #list_filter = ['date', 'team', 'competition'] > list_display = ('date', 'opponent', 'kickoff') > list_filter = ['date'] > search_fields = ['date'] > > class Result(models.Model): > fixture = models.OneToOneField(Fixture, core=True) > howdenscore = models.IntegerField("Howden Score", core=True) > opponentscore = models.IntegerField("Opponent Score", core=True) > > class Admin: > list_display = ('howdenscore', 'opponentscore',) > list_filter = ['howdenscore',] > search_fields = ['howdenscore'] > > I removed the help text and commented out what you didn't get us. :) > > Kai --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---