Linking (?) multiple tables

Creating tables and queries

Linking (?) multiple tables

Postby DNAtsol » Fri Mar 11, 2011 6:32 pm

Hi,
Newbie @ base and I may be in over my head but....

I'm trying to record the results of multiple races with the purpose of using prior results to predict current races. In each table I have the person's name, the team and race result. Sometimes the race takes place over several days and I have each individual stage as well as the overall finishing position.

I'd like to take a list people racing in an upcoming race, pull up their prior results from any race they may have been in to compare.
My thought is to make a master table, filter it based on current race participants and use the result to extract results from prior race results. Am I on the right track? If so, any pointers to get me going in the right direction would be most appreciated. If not, any suggestions on a better way to accomplish this appreciated even more :).

Participants in any one race do not completely overlap with any other race.
Thanks
DNAtsol
open office 3.3
Ubuntu 10.10
DNAtsol
 
Posts: 2
Joined: Fri Mar 11, 2011 3:37 pm

Re: Linking (?) multiple tables

Postby Villeroy » Fri Mar 11, 2011 7:19 pm

A typical use case for scenarios.
Example file: download/file.php?id=3004

Sorry, I did not notice that this is the Base forum.
You need a table of events(races), a table of possible winners (horses, riders, teams, whatever). A mapping table to constitute a many-to-many relation, a table of persons who bet linked to the events through a table of wagers (another n-n relation: person--wager--race).
First you fill out the events, the peoples table and the horses. Then you use many-to-many forms to map the related items to each other. A set of queries and reports will deliver the results.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26142
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Linking (?) multiple tables

Postby DNAtsol » Sat Mar 12, 2011 2:16 am

Ok. I think I follow your logic. I have one table of (for me) bike riders. Another single table for all the races for the season. What I'm confused on is the "mapping table" could you explain/describe/link to something that could get me an example of how I would do that.

Thanks for the reply
DNAtsol
open office 3.3
Ubuntu 10.10
DNAtsol
 
Posts: 2
Joined: Fri Mar 11, 2011 3:37 pm

Re: Linking (?) multiple tables

Postby Villeroy » Sat Mar 12, 2011 4:03 pm

Many-to-many (m-n) relations in the relations manager (Tools>Relations...), reflected in editable cross-table forms:
viewtopic.php?t=12125& [each movie has one or more genres and vice versa]
viewtopic.php?t=25934&p=117918#p117918 [each employee has one or more meeting with clients and vice versa]
download/file.php?id=8641 [each meal has one or more ingretient and vice versa]
Short tutorial on form design tools: viewtopic.php?f=83&t=32757
m-n form step by step: viewtopic.php?f=61&t=25562#p116320
There is no way to do this by means of wizards.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26142
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 3 guests