Hello, I am trying to create a sports team and league database. I need help. I have a team table (*id, teamname, coach id, ....) Coach table (*id, name, ...) I used adding existing fields into the team table adding the coach id and coach name. I have a schedule table (*id, season, week, team id1 and teamid2, .....) The team ids are add existing field form the team table. I then created a head to head table. using season an dtema id 1 and team id2 as the keys. i could only have 1 team id as a key not the other? any idead why? HAs some one already set one of these up and wants to share?