Hi guys,
I'm glad you guys are looking into this problem and helping me out.
I'll try to explain the following:
Setup:
two tables. one with all the main data and one with just name and a unique number.
in the main database i want to save the names and what the persons have done.
e.g.
It's a sports databse that we will use during training. Every exercise we want to have 'documented'. There will be 7 people involved everytime. For a session non of the players will be different part from maybe a starting position. This is why i dont want to pick the names everytime again from the names table to save it to the main table.
We run two teams against eachother where every team will ahve 3 goes at a time after which they rest and let the other team practice. In total 30 each.
All other fields part from one are Yes/No fields for the different outcomes. e.g. left, right, low, wide, score etc etc The one other field is a time field.
During the physical excersise I'd like to keep track of some of the data. Like the times we executed the excersise and the amount of goals etc.
at the end of a session i like to see how many times what ahs happened. Again a sientific outcome. how many times did a player score, put the ball wide, got in action etc etc
hope this brings a bit more clearity to what i like to achieve and the problems i'm facing.
By the way i'm a bit lost with the terms bound and unbound...
I'm glad you guys are looking into this problem and helping me out.
I'll try to explain the following:
Setup:
two tables. one with all the main data and one with just name and a unique number.
in the main database i want to save the names and what the persons have done.
e.g.
It's a sports databse that we will use during training. Every exercise we want to have 'documented'. There will be 7 people involved everytime. For a session non of the players will be different part from maybe a starting position. This is why i dont want to pick the names everytime again from the names table to save it to the main table.
We run two teams against eachother where every team will ahve 3 goes at a time after which they rest and let the other team practice. In total 30 each.
All other fields part from one are Yes/No fields for the different outcomes. e.g. left, right, low, wide, score etc etc The one other field is a time field.
During the physical excersise I'd like to keep track of some of the data. Like the times we executed the excersise and the amount of goals etc.
at the end of a session i like to see how many times what ahs happened. Again a sientific outcome. how many times did a player score, put the ball wide, got in action etc etc
hope this brings a bit more clearity to what i like to achieve and the problems i'm facing.
By the way i'm a bit lost with the terms bound and unbound...
