You're not rolling d20s for these skills are you?
You need an additional table. We call it a Join table and it will contain the fields CharacterSkillID, Character ID, SkillID, Skill Value.
Actually this is for a role-playing game system. ;)
Join tables... I think I can see where this is getting too. Thanks for the hint!
Ok, I understand the logic of the table relations now but still I can't figure out how to have the entries from the skills table to show up automatically in the characters table. I could connect them by manually entering their IDs but I'd rather want all available skills to be listed (optimally with their name, not their ID) in the characters table so that a value can be comfortably entered for each skill.
Nevermind! I figured it out by following these tutorials ... http://filemakertoday.com/com/blog.php/13702-Weetbicks?blogcategoryid=14
The only thing that is still left to do is to auto-populate the portal with skill entries but I suppose that can only be done with scripting, right?