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

[Bob Quintal]

"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

[Pieter Linden]

> 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.

[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