Hi Guys,

I have had various people help me but the only design that seems to work is the 1st desigin that i came up, with and you know what they say if it ant broke then dont fix it.

But I want someone to help me fix it .



http://www.box.com/s/4rmrkrqbz9y8by6ihlao

From the link attached I need a new design for this database and I need the new design to do exactly what this database does.

some pointers, the team i select will very from week to week so it will not be the same team that i pick.

If my player scores 21 at home the player gets two points away my player gets 3 points.

I need the main data entry from to look like this

Team Name Date of Game Home/Away

Player Name Our Score Opp Score points.

Then I need the new database to produce the querys that i have in the link above.

Can anyone help with this please.