Very new to DB stuff. I am making a database to track statistics for a hockey team. Wins, losses, individual player stats like goals assists etc. my tables are laid out as follows:
Table BDIV_teamstats contains:
Table BPlayers Contains:
Table BPlayerstats contains:
staPlayerID (related to Bplayer; PlayerID)
StaGameid (related to BDIV_teamstats; Gameid
I have created a relationship between these tables as I indicated above. When there is no data in the pages, everythign is fine. As soon as I enter data I get an error:
"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables. (Error 3071)"
Is this because of Primary keys possibly being the same number? I have been told about Foreign Keys? - would doing that help? I really dont know how to create them.