Hello all,
I've recently began working on a project and I think I may have over complicated things a bit.
I'm building a database to use for scouting players in a video game, a bunch of friends and I used an excel version last year and I'm trying to upgrade it now.
What I have in mind is this:
Each position has a specific set of skills that are important to them, for example, a running backs important skills would be speed, agility, acceleration, vision, and elusiveness. A quarterbacks important skills would be speed, agility, acceleration, throwing power, and throwing accuracy.
I'm attempting to create a form that when a position is selected, only that positions important skills show up. Example being, user opens the form>inputs basic information>selects position(RB) and only speed, agility, acceleration, vision, and elusiveness show up on the form.
I've made three tables thus far; a Prospects table with all the basic information for the scouted player, a Positions table with position names, and a Skills table with every single possible skill listed.
Now I'm drawing a blank on how to connect this all together to complete my vision
Any help is greatly appreiated