League Table design

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

re: League Table design

"Ram" <ram0na@hotmail.co.uk> wrote in
news:FCDfc.766$1v1.379@newsfe1-gui.server.ntli.net:
[color=blue]
> 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.
>[/color]
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
[color=blue]
>
> FIA
> Ram
>
>
>[/color]

re: League Table design

> I am trying to set up a DB for a race series where a riders best 6 of 10[color=blue]
> 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[/color]

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.

re: League Table design

Thx for both your replys

Ram


"Bob Quintal" <bquintal@generation.net> wrote in message
news:c5aacabf9b9a305ed1c1bfa9f35e3d6a@news.teranew s.com...[color=blue]
> "Ram" <ram0na@hotmail.co.uk> wrote in
> news:FCDfc.766$1v1.379@newsfe1-gui.server.ntli.net:
>[color=green]
> > 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.
> >[/color]
> 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
>[color=green]
> >
> > FIA
> > Ram
> >
> >
> >[/color]
>[/color]