Problem with Linked tables writing to database

I have a linked tables set up to get teams and team codes from the teams table in the database. This is setup on the registration page. When it writes the data to the registration table it writes the first part of the Team Name into the TeamCode field when it should be writing the TeamCode field into the TeamCode. I'm using PHPRunner 3.1 Build 212
Here is the zip file of the stuff.

http://www.flashresultsonline.com/Database.zip
Thanks!