I have a bit of a issue here. I am practicing with Access by using it for my Star Wars Roleplaying Game. I have learned a bit about how tables work, but for the life of me I can't figure this out.
Now, in the roleplaying game you can have up to X amount of different classes, and each class you take can be X amount of levels. For example, let us say I want to be a Level 2 Jedi and Level 8 Noble, in turn would make my "Character Level" a total of 10.
My question is: Is there a way that I can have multiple ForeignKeys in the same box or will I have to make 100 different tables?
Here is a picture of my current set up: