can this be done in Access?

I am trying to create a schedule for my crosscountry teams meets with other
teams. Here is the info: I have 15 high school teams that need to meet with
each other once. I can have meets that conists of two teams against each
other or meets that have three teams against each other. I don't need
specific dates for the meets, I am just hoping Access can arrange the groups.

Can this be done in Access? It seems like something a database can do but I
am not sure where to even start.

Thanks
Dola

Create a table of teams containing teamid (autonumber),
tean name. Create a schedule table containing scheduleid,
date, teamid. So if your meet has three teams, your
schedule table will have three records. Resist the
tempatation to have a schedule table with scheduleid,
date, teamid1, teamid2, teamid3.
Good luck.
Geof Wyght
-----Original Message-----
I am trying to create a schedule for my crosscountry
teams meets with other
teams. Here is the info: I have 15 high school teams
that need to meet with
each other once. I can have meets that conists of two
teams against each
other or meets that have three teams against each other.
I don't need
specific dates for the meets, I am just hoping Access can
arrange the groups.

Can this be done in Access? It seems like something a
database can do but I
am not sure where to even start.

Thanks
Dola

.

Thanks for the reply. I created the tables but I still can't figure out how
to get Access to merge the data to create a schedule of meets/grouping of
teams for me. Is scheduleid the primary key? Is it because I don't have
specific dates in mind? What type of query do I need to create?

Thanks so much for any help.

Wendy

"Geof Wyght" wrote:

Create a table of teams containing teamid (autonumber),
tean name. Create a schedule table containing scheduleid,
date, teamid. So if your meet has three teams, your
schedule table will have three records. Resist the
tempatation to have a schedule table with scheduleid,
date, teamid1, teamid2, teamid3.
Good luck.
Geof Wyght
-----Original Message-----
I am trying to create a schedule for my crosscountry
teams meets with other
teams. Here is the info: I have 15 high school teams
that need to meet with
each other once. I can have meets that conists of two
teams against each
other or meets that have three teams against each other.
I don't need
specific dates for the meets, I am just hoping Access can
arrange the groups.

Can this be done in Access? It seems like something a
database can do but I
am not sure where to even start.

Thanks
Dola

.

Wendy,
Please have a look at and download the database that I
put together for you at:
http://home.fuse.net/Wyght/teamschedule.mdb
Have a look at Tools, Relationships. The Hungarian naming
conventions (tbl, QSEL).
Geof Wyght.
-----Original Message-----

Thanks for the reply. I created the tables but I still
can't figure out how
to get Access to merge the data to create a schedule of
meets/grouping of
teams for me. Is scheduleid the primary key? Is it
because I don't have
specific dates in mind? What type of query do I need to
create?

Thanks so much for any help.

Wendy

"Geof Wyght" wrote:

Create a table of teams containing teamid
(autonumber),
tean name. Create a schedule table containing
scheduleid,
date, teamid. So if your meet has three teams, your
schedule table will have three records. Resist the
tempatation to have a schedule table with scheduleid,
date, teamid1, teamid2, teamid3.
Good luck.
Geof Wyght
-----Original Message-----
I am trying to create a schedule for my crosscountry
teams meets with other
teams. Here is the info: I have 15 high school
teams
that need to meet with
each other once. I can have meets that conists of
two
teams against each
other or meets that have three teams against each
other.
I don't need
specific dates for the meets, I am just hoping Access
can
arrange the groups.

Can this be done in Access? It seems like something
a
database can do but I
am not sure where to even start.

Thanks
Dola

.


.