469,648 Members | 1,654 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,648 developers. It's quick & easy.

League Table design

Ram
Hi,

I am trying to set up a DB for a race series where a riders best 6 of 10
rides count towards a league position.

I have a table of Riders ( say 300 )
I want to use a form to select which riders from the Riders Table are taking
part and create a new Event Table ( say Round 1 ) max of 120 riders per
event.

How do I go about creating the new table from the form.
Say, I've selected my 1st rider then create a new table 'Round 1' with Make
Query Table " I believe" but when it comes to the 2nd Rider I've selected do
I have to Append to the new Table ?
Basically I need a DB where I can select the Riders from a list ( or add
riders to it, if their are a new competitor ) to create a List of Riders per
Event, once the event as been run, I then enter the race order and award
points. 1st place 120 pts, 2nd 119pts and down. After the 10th event I then
create the League Table consisting of the riders best 6 from 10 events

I've been using XL for the last couple of season and I hoping to simplify
thing by using Access.
FIA
Ram
Nov 12 '05 #1
3 3513
"Ram" <ra****@hotmail.co.uk> wrote in
news:FC***************@newsfe1-gui.server.ntli.net:
Hi,

I am trying to set up a DB for a race series where a riders
best 6 of 10 rides count towards a league position.

I have a table of Riders ( say 300 )
I want to use a form to select which riders from the Riders
Table are taking part and create a new Event Table ( say Round
1 ) max of 120 riders per event.

How do I go about creating the new table from the form.
Say, I've selected my 1st rider then create a new table 'Round
1' with Make Query Table " I believe" but when it comes to the
2nd Rider I've selected do I have to Append to the new Table ?
Basically I need a DB where I can select the Riders from a
list ( or add riders to it, if their are a new competitor ) to
create a List of Riders per Event, once the event as been run,
I then enter the race order and award points. 1st place 120
pts, 2nd 119pts and down. After the 10th event I then create
the League Table consisting of the riders best 6 from 10
events

I've been using XL for the last couple of season and I hoping
to simplify thing by using Access.
You are trying to use Excel concepts in Access.You don't create a
new table for each event, you add rows to the event-riders table.

All you need, if you think about it, in the event-riders table,
is the ID number of the event, the ID number of the rider, and
place to add each rider's preformance during the event.

You then use a filter to restrict the information to the event
you are currently working on.

The basic design becomes

Table:Riders,
field RiderID,
Riders.lastname,
Riders.firstname
Riders.phone_Number
etc.

Table:EVents
field:EventID
Events.title
Events.EventDate
Events.eventLocation
etc.

And Table Events_Riders
field: EventID
RiderID
RiderTime
RiderStartNumber
RiderFinishPosition
RiderRunTime.
etc.

The event inscription form then presents you with two comboboxes,
The first shows future events, (you don't want to enter someone
in a race that is finished), and the second lists possible riders
They just add a new record to the permanent Events_Riders,
putting in the two relevant ID numbers. No queries needed, the
form does everything.

The event Results form lets you select from events whose date is
passed. and select a rider, then input his performance data.

Yoour league table isn't a table, just a report, filtering on the
year(or race season), and doing all the calcs required there.

Bob Quintal

FIA
Ram


Nov 12 '05 #2
> I am trying to set up a DB for a race series where a riders best 6 of 10
rides count towards a league position.

I have a table of Riders ( say 300 )
I want to use a form to select which riders from the Riders Table are taking
part and create a new Event Table ( say Round 1 ) max of 120 riders per
event.

How do I go about creating the new table from the form.
Say, I've selected my 1st rider then create a new table 'Round 1' with Make
Query Table " I believe" but when it comes to the 2nd Rider I've selected do
I have to Append to the new Table ?
Basically I need a DB where I can select the Riders from a list ( or add
riders to it, if their are a new competitor ) to create a List of Riders per
Event, once the event as been run, I then enter the race order and award
points. 1st place 120 pts, 2nd 119pts and down. After the 10th event I then
create the League Table consisting of the riders best 6 from 10 events

I've been using XL for the last couple of season and I hoping to simplify
thing by using Access.
FIA
Ram


Ram,
this should probably be structured like this:
Rider---(1,M)---RiderEvent--(M,1)--Event

Each Rider can compete in multiple Events, and each Event can have
multiple riders. Then you could have a field in "RiderEvent" that
would have the place the rider came in. The rest you could do with
queries.
Nov 12 '05 #3
Ram
Thx for both your replys

Ram
"Bob Quintal" <bq******@generation.net> wrote in message
news:c5******************************@news.teranew s.com...
"Ram" <ra****@hotmail.co.uk> wrote in
news:FC***************@newsfe1-gui.server.ntli.net:
Hi,

I am trying to set up a DB for a race series where a riders
best 6 of 10 rides count towards a league position.

I have a table of Riders ( say 300 )
I want to use a form to select which riders from the Riders
Table are taking part and create a new Event Table ( say Round
1 ) max of 120 riders per event.

How do I go about creating the new table from the form.
Say, I've selected my 1st rider then create a new table 'Round
1' with Make Query Table " I believe" but when it comes to the
2nd Rider I've selected do I have to Append to the new Table ?
Basically I need a DB where I can select the Riders from a
list ( or add riders to it, if their are a new competitor ) to
create a List of Riders per Event, once the event as been run,
I then enter the race order and award points. 1st place 120
pts, 2nd 119pts and down. After the 10th event I then create
the League Table consisting of the riders best 6 from 10
events

I've been using XL for the last couple of season and I hoping
to simplify thing by using Access.

You are trying to use Excel concepts in Access.You don't create a
new table for each event, you add rows to the event-riders table.

All you need, if you think about it, in the event-riders table,
is the ID number of the event, the ID number of the rider, and
place to add each rider's preformance during the event.

You then use a filter to restrict the information to the event
you are currently working on.

The basic design becomes

Table:Riders,
field RiderID,
Riders.lastname,
Riders.firstname
Riders.phone_Number
etc.

Table:EVents
field:EventID
Events.title
Events.EventDate
Events.eventLocation
etc.

And Table Events_Riders
field: EventID
RiderID
RiderTime
RiderStartNumber
RiderFinishPosition
RiderRunTime.
etc.

The event inscription form then presents you with two comboboxes,
The first shows future events, (you don't want to enter someone
in a race that is finished), and the second lists possible riders
They just add a new record to the permanent Events_Riders,
putting in the two relevant ID numbers. No queries needed, the
form does everything.

The event Results form lets you select from events whose date is
passed. and select a rider, then input his performance data.

Yoour league table isn't a table, just a report, filtering on the
year(or race season), and doing all the calcs required there.

Bob Quintal

FIA
Ram

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by mksql | last post: by
3 posts views Thread by Ram | last post: by
8 posts views Thread by Stewart Allen | last post: by
6 posts views Thread by MLH | last post: by
4 posts views Thread by lorirobn | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.