D
Doctor
I have a table called tblChurchTeams with the following structure
ChurchTeamID, ChurchID, EventID, NumberOfTeams
1, 1, 1, 2
2, 1, 2, 4
3, 1, 3, 2
4, 1, 4, 2
etc...
I would like to make another table from this table but I would like one
record in the new table for each team that was entered in the previous table
in the NumberOfTeams field.
MakeTable Desired Structure:
TeamID, ChurchTeamID, Team Number
1, 1, 1
2, 1, 2
3, 2, 1
4, 2, 2
5, 2, 3
6, 2, 4
etc...
For instance, in the first table it says how many teams the church has for a
particular event. I want the second table to split the number of teams they
have into one record for each team.
Perhaps there is a simpler way to accomplish this; I am open to suggestions.
Any help and advice would be greatly appreciated.
ChurchTeamID, ChurchID, EventID, NumberOfTeams
1, 1, 1, 2
2, 1, 2, 4
3, 1, 3, 2
4, 1, 4, 2
etc...
I would like to make another table from this table but I would like one
record in the new table for each team that was entered in the previous table
in the NumberOfTeams field.
MakeTable Desired Structure:
TeamID, ChurchTeamID, Team Number
1, 1, 1
2, 1, 2
3, 2, 1
4, 2, 2
5, 2, 3
6, 2, 4
etc...
For instance, in the first table it says how many teams the church has for a
particular event. I want the second table to split the number of teams they
have into one record for each team.
Perhaps there is a simpler way to accomplish this; I am open to suggestions.
Any help and advice would be greatly appreciated.