Linking (?) multiple tables
Posted: 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
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