can this be done in Access?

[dwae2000]

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

 

[Geof Wyght]

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

 

[dwae2000]

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]

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.