Change number of teams and team names

[alexanderf]

Who can help me with my access database.
I want to change the maximum teams in 19 teams instead of the 12 teams
And change the team names ito: Team 1 and Team 2

I have closed by the databases



Thanks

[ranman256]

I would make a tConfig table. In it a MaxTeams field.
then when you are entering teams into a season, it checks this number as the limit.

make an update query , change oldName to Team1 . Etc.

[alexanderf]

I would make a tConfig table. In it a MaxTeams field.
then when you are entering teams into a season, it checks this number as the limit.

make an update query , change oldName to Team1 . Etc.

How do you do that???

[aytee111]

Please provide more details. There are three tables that I can see that carry the team. What do you want your data to look like once the updates have been done?

Note: with naming conventions, whenever a field is on more than one table always give it the same name, e.g. Team ID. And never use "ID", it is meaningless. Also, no spaces or funny characters in field names.

[alexanderf]

I must have teams with 6 people in it so i must have 18 or 19 teams.

Now i have only 12 teams with more than 6 people in it.

And i want to change also the team names from:
Balpen in Team 2
Kladblok in Team 12

[aytee111]

First get your table structure correct:
- a table containing teams with TeamID and TeamName
- a table of people containing PersonID and PersonName (not sure what those other fields are)
- a table that is a cross-reference, containing TeamID and PersonID

Once you have created this structure and put data into the first two tables, repost your database so that we can get a better understanding of where you want to end up. Is this an ongoing database, will you be adding more people and making up more teams?