You are most likely missing the spells. I'm not sure if I covered this in the tutorials. If I didn't I should. The best flow for creating a database with architect is the following
Start with tables that have no dependencies: talents, statistics, Herbs, encounters, etc.
Next make sure any table with dependencies, you complete the depended tables first. For with Spells, make sure you have spells defined. I don't have this particular program in front of me now, but I believe when it comes to the spells tab, complete your spells first. Then create spheres and add your spells to the spheres.
Hope that helps.