This sounds like a many to one relationship which you intend to keep track of correct?
The purpose of the foreign key constraint is a preemptive effort to maintain the integrity of the data within the database (ie: orphan control). So for examples, if I had two tables (ignoring the third as the user table) called gamecodes and usergamecodes, I would have gamecodes with even a single field, which I'll call gamecode. My records look like so:
So three game codes in total.
Now I have the second table, usergamecodes (also with a key constraint to user), with the columns: userid, gamecodes, and lets say, dateclaimed. userid and gamecode are both foreign keys, and are a composite primary key. My data looks like so:
Code:
1 | AAA | 2013-01-17
1 | CCC | 2013-01-22
2 | AAA | 2013-02-14
3 | AAA | 2012-12-12
If I attempt to insert 1, DDD, 2013-02-14 for example, I would receive the error back from SQL server with the errno value of (lets see if I can get these right from the manual :P), 1452 which is a key constraint violation. This occurred since table gamecode does not include a gamecode of DDD.
If I were to attempt to insert 1, CCC, 2013-02-14, I would receive an error 1062 since userid 1 and gamecode CCC primary keys are already in use (ie: duplicate).
The thing I'm not sure of here is if I'm hung up on the INSERT part of your title or not. I'm not sure if these actually need inserting (hence my first reply indicating to just select if you don't need to insert anything).