Compare Query

[^Halibut^]

i'm trying to create a Access DB to help me setup a youth sports league. i
need to be able to group people together that want to be on the same team.
So, if Johnny Miller wants to play on the same team as Bobby Johnson they
get put in the same group.

i know how to setup the tables and create reports based on age and other
fields, but, i'm can't figure out how to solve this problem.


any suggestions. thanks in advance!!

 

[John Vinson]

i'm trying to create a Access DB to help me setup a youth sports league. i
need to be able to group people together that want to be on the same team.
So, if Johnny Miller wants to play on the same team as Bobby Johnson they
get put in the same group.

This is a classic One (team) to Many (player) relationship.

Create a Table of Teams with TeamName as the Primary Key (you don't
really need a numeric ID in this case, just be sure that the names of
your teams are all different). Add the TeamName field to the Player
table; to put Johnny and Bobby both on the Hawks, just put "Hawks" in
the TeamName field of their records. This will serve as a link to the
Teams table, and as a searchable field to find all the Hawks, or group
by teamname, or whatever.

 

[^Halibut^]

I don't think that will work since they won't be registering at the same
time and i may not have the other player registered yet. Also, the # of
teams will depend on the number of people that register.

i'll only have a field called "GroupWith" that will have a name of another
player they would prefer to be grouped with. Does that make sense? how
would you suggest i handle this?

 

[John Vinson]

i'll only have a field called "GroupWith" that will have a name of another
player they would prefer to be grouped with. Does that make sense?

Only if each player will be grouped with one and only one other
player. What would be in the GroupWith field for Jim if Jim is grouped
with six other boys? A field can only have ONE value!

how would you suggest i handle this?

As I suggested previously. There's no need to have all the players or
all the teams created to start with - you can start with one team,
TeamA, and assign players to it until it's full, then start building
TeamB and so on. Teams can be reassigned whenever necessary simply by
editing that