Originally posted by Revivo_10
I have a problem...
I download ECP's Access Editor...
But I can't open with Creation Center...
This Error :
Run time Error '-2147467259 (80004005)':
You cannot add or change a record because a related record is required in table 'Teams'.
What's my problem ?
have you read Hakeems tutorial?
download from SoccerAccess and read about kits you need five kits per team
you need to make team numbers from autonumber to number
_________________________
this is what Alex (sKIp_E) gave me and has worked like a treat
reinstall CC get the new access database and work this to the letter
Adding teams with Access:
Go Tools-Relationships.
Delte Relationships from Teams(ID) to Link_PT, Link_TC and Link_TF
Save
Open Teams table in design view.
Change ID from autonumber to number
Save
Go Tools-Relationships.
Rebuild relationships between teams(id) and link_pt(team), link_tc(team) and link_tf(team)
WHEN YOU REBUILD THESE, YOU WILL BE ASKED IF YOU wANT TO ENFORCE REFERENTIAL INTEGRITY. TICK THIS BOX! Also make sure u go from teams(id) to link_XX(team), in that order and not to link_xx(id)!!!
Ok now to add teams.
Firstly, go to the kits table, and add 5 kits. To find the numbers style, copy a team that you know has the same number and name style (this usually goes with brands, so if you're adding a Nike team, just copy it from another Nike team etc). To find colours, open the colour table.
MAKE SURE THAT FOR THE KITS YOU WANT TO USE, THE "isgeneric" tick box is NOT selected.
1st kit=home kit
2nd kit=away kit
3rd kit=Alt kit
4th Kit=GK kit
5th kit, JUST LEAVE THE ISGENERIC BOX TICKED FOR THIS KIT!
Once youve set up the teams kits.
Go to the teams table (NOT FORM!), and add a team with an ID, starting as low as u can (which should be around 1800).
Make its 1st, 2nd 3rd 4th 5th kits the 5 kits you just added.
save
Now go to the teams form, and simply add the players u want in the team!
Set the teams formations etc!
And away u go.
Make sure u add atleast 16 players (11 starting 5 subs), and no more then 32.
Open Link_TF table, and add a row/record, with ur teams ID number in the team field, and 78 in the federation field if it is a National Team, or 76 if your team is a club (it will appear in "rest of world")
Now
Download and install kit raptor and flags raptor.
Open the directory their exe's are in (easily found by right clicking on a shortcut, going properties, and then "find target")
Open Teams.ini, and add a line to the file that has:
"YOURNEWTEAMSNAME",XXXX
where XXXX is your new teams id number (NOT KIT NUMBER!)
Do the same thing to teamsfl.ini which can be found in the same folder.
Import flags, and kits using Kit Raptor and Flags Raptor. Only the kits that you unselected isgeneric for will show up in the game.
Now run the CC, file new. File save (save the BLANK package), and then install the package.
DONE!
) the worlds after you say the sentence. 
(GrinX)
