OK, I have a table that will have score entered...
TABLE1:
teamA,Ascore,teamB,Bscore
What I need to do is the following:
Each team will have their own table:
TEAMA Table:
w,t,l,rf,ra
So from first table when a score is entered I want to insert data into the team's table as follows...
If Ascore > Bscore
insert 1 into TEAMA table in w and Ascore into TEAMA table in rf
If Ascore = Bscore
insert 1 into TEAMA table in t and 1 into TEAMB table in t
etc,etc...
Any help in starting would be great!
Thanks