Need help please.

[reeve50]

I'm new to access and need so advise.

I'm trying to create a table that will allow me to create a weekly schedule for my son's basketball league. I have the ten teams set up in a table, but I can't picture how I would set things up so I could run a query to show me who plays whom in each week.

Any suggestions would be greatly appreciated.

 

[Rich_Lovina]

Always start by outlining your database design on paper, then draw a report of what fields of info you want where.

Then study the Northwinds sample and look for similarities.
Then use the search key, and read the many sample questions.

Start by putting each team in a separate table, then put date and venue in another table. Create a link key, uinque identifier for each team.