I'm trying to build a Netball League website for a client. Here are the object relations for the Data Objects:
NetballTeam has_one Division
Netball Team has_many Match
Division has_many NetballTeam
Division has_many Match
Match has_many NetballTeam (I've resticted this to 2 by counting how many there are removing the add/link functionality when the limited is reached)
Match has_one Division
Match has_one MatchGroup
MatchGroup has_many Match
The problem I'm having is linking the match result to the team, so for example team A score 3, and team B score 5.
This I can then use to detect the winner, etc.
Any ideas on how to do this?
Thanks in advance for all your help.