473,379 Members | 1,235 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

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 3825
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: mksql | last post by:
As an example, I am building an authentication mechanisim that will use data in the 3 left tables to determine rights to objects in a destination table, diagrammed below. In this structure,...
3
by: Ram | last post by:
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...
8
by: Stewart Allen | last post by:
Hi Just asking for ideas on table design. The design I have is as follows: *tblBuildData* BuildID (PK) AutoNumber ManufactureDate SerialNumber
6
by: MLH | last post by:
If I open an A97 table, resort its key-field to descending order and attempt to close the table, A97 asks me if I wish to save the table DESIGN? Now really, I don't think the table design is being...
4
by: lorirobn | last post by:
Hello, I'd be curious to hear other thoughts on my database and table design. My database is for 'space use' in a lodging facility - will hold all spaces, like rooms (lodging rooms, dining...
1
by: keliie | last post by:
I have a relatively simple (I assume) issue which I am at a complete loss to address. My issues is: I want to populate fields in my tables with summary data from the same table. Let me explain: ...
3
by: stephenf33 | last post by:
Hi All I was wondering if anyone knew how to or has developed an access database that could record exam scores and then copy information onto another form as a league table, showing the highest...
2
by: tommurray | last post by:
Iím looking for a little help and guidance on creating a league table from entries in a database, because of other requirements it is not possible to update the entry for the person in the database....
0
by: jsimone | last post by:
This question is about DB2 table design and performance. We are using DB2 UDB Enterprise 8.2 on Linux. We have 6 tables in a parent-child (one-to-many) relationship with each other. Each...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.