I have 2 classes: class Player(models.Model): team = models.ForeignKey(Team) forename = models.CharField(maxlength=50) surname = models.CharField(maxlength=50) age = models.PositiveIntegerField() sex = models.CharField(maxlength=1, choices=Gender_Choices) class Admin: pass list_display = ('forename', 'surname', 'age', 'team', 'sex') list_filter = ['team'] search_fields = ['forename'] #String method def __str__(self): return self.surname
and class Result(models.Model): team = models.ForeignKey(Team) venue = models.CharField(maxlength=1, choices=Fixture_Choices) date = models.DateField() opponent = models.CharField(maxlength=100) competition = models.ForeignKey(Competition) howdenscore = models.IntegerField() opponentscore = models.IntegerField() goalkeeper = models.ForeignKey(Player) leftback = models.ForeignKey(Player) centreback1 = models.ForeignKey(Player) centreback2 = models.ForeignKey(Player) rightback = models.ForeignKey(Player) leftmid = models.ForeignKey(Player) centremid1 = models.ForeignKey(Player) centremid2 = models.ForeignKey(Player) rightmid = models.ForeignKey(Player) striker = models.ForeignKey(Player) striker = models.ForeignKey(Player) sub1 = models.ForeignKey(Player) sub2 = models.ForeignKey(Player) sub3 = models.ForeignKey(Player) sub4 = models.ForeignKey(Player) sub5 = models.ForeignKey(Player) class Admin: pass list_display = ('date', 'team', 'venue', 'opponent', 'competition', 'howdenscore', 'opponentscore') list_filter = ['date', 'team', 'venue', 'competition'] search_fields = ['date'] def __str__ (self): return self.opponent However when I try and run syncdb I get the following error: teams.result: Accessor for field 'sub5' clashes with related field 'Player.result_set'. Add a related_name argument to the definition for 'sub5'. teams.result: Accessor for field 'sub5' clashes with related field 'Player.result_set'. Add a related_name argument to the definition for 'sub5'. *Note that I get the same error for each of the fields from goalkeeper through to sub5 (all are foreignkeys of player) Am I going about it in the right way? Or is my modelling wrong? What I'm trying to achieve is having a table full of players, and for a result I want to see which 17 of those players were at the game (to calculate appearances later on) so the results page would be such like: Team A vs Team B 10th March Old Trafford 2-1 Gary Neville Edwin Van der Saar Patrice Evra Rio Ferdinand Wayne Rooney etc (listing the full team who played and the subs chosen) Many thanks, Duncan --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---