gbmarlysis
Registered User.
- Local time
- Tomorrow, 02:59
- Joined
- Jan 30, 2012
- Messages
- 28
Hi,
We need a db for our athletics club.
i have split the tables into three categories
1) Athlete Table
-Athlete ID (primary key)
-Name
-Age
-Sex
2) Race Table
-Race ID (primary key)
-Date
-Age Division
-Distance
-No. of entrants
-Track
3) Race Results Table
-Race result ID (primary key)
-Position
-Coach (changes regularly)
-Time
I put the Race Id and Athlete Id in the Race Results Table and created a 1 to many link.
Is this correct?
Our main reason for the post is we want to create one form for entering in all the data.
First put in the athletes name, if it doesnt automatically fill in the other boxes then put in their info.
second put in the race they just ran in, again if its already in a table autfill in the boxes but if not then fill in the details.
Then a list of all the races logged for them to come up on the form so you can see all their entered races.
If current race hasn't been entered then put in position, time etc then enter.
So if we put in a new athlete
or a new athlete with a new race description with a new result
or an entered athlete with a new race description with new result
or an entered athlete with an entered race description but new result
or just check what races of an athlete have been entered
could that all be done on one form
Many many thanks in advance for people taking the time to try and help us.
If i have been unclear let me know.
TY
LB
We need a db for our athletics club.
i have split the tables into three categories
1) Athlete Table
-Athlete ID (primary key)
-Name
-Age
-Sex
2) Race Table
-Race ID (primary key)
-Date
-Age Division
-Distance
-No. of entrants
-Track
3) Race Results Table
-Race result ID (primary key)
-Position
-Coach (changes regularly)
-Time
I put the Race Id and Athlete Id in the Race Results Table and created a 1 to many link.
Is this correct?
Our main reason for the post is we want to create one form for entering in all the data.
First put in the athletes name, if it doesnt automatically fill in the other boxes then put in their info.
second put in the race they just ran in, again if its already in a table autfill in the boxes but if not then fill in the details.
Then a list of all the races logged for them to come up on the form so you can see all their entered races.
If current race hasn't been entered then put in position, time etc then enter.
So if we put in a new athlete
or a new athlete with a new race description with a new result
or an entered athlete with a new race description with new result
or an entered athlete with an entered race description but new result
or just check what races of an athlete have been entered
could that all be done on one form
Many many thanks in advance for people taking the time to try and help us.
If i have been unclear let me know.
TY
LB
