The Student Room Group

ITO6- access database please HELP!

ive created a query for tennis matches and members playing, the query links to a sub-form on which i can enter the match played by a particular member, in the query there is members table linked one-to-many to the matches table ive also linked player 2, 3 and 4 in the match table to duplicate member tables 1,2 and 3 in respectively. this is so that wen a player 2 is entered in members matches it will also be entered in the player 2 member part. however when i try to enter data it dosnt allow me to and on the bottom i see the error, "cannot add records join key of table match not in record set"
please can someone help! :confused:
Thanks