Thank you for the pointer Malcom, however you are only using 2 tables/classes (Player which is directly related to Match) The problem I am having is because I am using 3 tables/classes (Team is related to fixture, Fixture is related to Result) so I do not know how to get around that without having to duplicate data in my result table (e.g. repeating the information such as home team, away team, date, venue) etc. Which I am trying to avoid as much as possible because the data wouldn't be normalised.
Do you know a way of achieving this? Regards, Duncan On Mar 14, 9:10 am, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > On Wed, 2007-03-14 at 00:13 +0000, DuncanM wrote: > > I have a schema as follows: > [...] > > How would I get it so I had a template that showed: > > Result > > Team A 0 - 3 Team B 22/03/07 > > > e.g. the homeTeam and awayTeam are pulled from Fixture, which pulls > > from Team, and Date is pulled from Fixture (according to the > > fixture_id) in Result, along with the homeScore and awayScore values > > of result?? > > I talked about a somewhat simplified version of this problem in a > tutorial I gave recently. You may get some help from the slides and/or > the code athttp://www.pointy-stick.com/lca2007/. > > Regards, > Malcolm --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---