Database design

F

Fipp

I am trying to set up a database in which I have a table that contains
information about plays from a football game. I then have another table that
contains information about players and the way they played during each
particular play. these tables are linked. My challenge is that I would like a
form that has the ability to input data on 2 different positions during each
play at the same time. I am thinking that there must be a way to do this?
This would allow me to not have to input the information on the play twice?

table_1
play#
call
gain

table_2
position
player
tackles
assits
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top