sql - MS Access - VBA to add data in all tables -

i have 68 tables in database , want add data these tables 1 click.

the purpose of database determine in position specific player more proficient; have table (tblmain) contains attributes (pace, acceleration, dribbling, etc) , remaining 67 tables have specific attributes (pace & dribbling - tblposition1).

what want achieve is: user add player attributes , click on save - upon clicking on save, attributes inserted tblmain , on other tables relevant attributes (i.e. tblposition1 want add pace , dribbling).

i can achieve having 68 different insert statements looking more quicker way if have suggestion.

edit: better understanding:

this table roles

attributes      role1      role2     ...     role68 ___________________________________________________ attr1           primary    secondary ...      attr2                      primary   ...     primary   .   .   . attr36          primary              ...     secondary 

this tables athletes' data

attributes      athlete1   athlete2   ...    atlhete7 _____________________________________________________ attr1           4          2          ...    5 attr2           8          4          ...    1   .   .   . attr36          2          3          ...    6 

what want each role average of (primary attributes * 0.7) + average of (secondary attributes * 0.2) + average of (remaining attributes * 0.1).

i know that's not possible 1 sql problem more complex things not able find solution.