Need to write several records based on one

[jnh]

Hi,

Have a table with 18 fields and based on content of a given field I might have to create a new output record. This means that it could be possible that the need for 18 new records for every input record may exist. All new records must go into the same new table. Any suggestions, Thanks...jnh

 

[plog]

Yes, provide more detail about the entire process. Specifically include data examples of records that would need to create new records and records that would not and explain why. Also, provide an example of what data from that example would go into this new record and why.

 

[jnh]

There are:

200+/- Teams (each Team identified by a TeamID) - table is loaded
15 Weeks per season (1-15)
5 PlayDays (Mon,Tue...Fri)
3 PlayTimes for any given PlayDay (AM/MidDay/PM)
6 PlayingFields (1-6)
Total: Up to 18 games per PlayDay BUT there are usually less games
on any given day (due to BYEs)

2000 +/- players in Team file where keys = TeamID and PlayerID
(where PlayerID is just a sequential # assigned when first entered)

Schedules are decided by Board.

I must generate a Score sheet (used by coaches and refs) for EACH
scheduled game showing:
Week number (1-15)
PlayDay (Mon,Tue...Fri)
PlayTime (AM/MidDay/PM)
PlayingField (1-6)
HomeTeam (by TeamID)
VisitorTeam (by TeamID)
Team Name (included in Team file using a special PlayerID)
Players info (name ++) for ALL players on HomeTeam
Players info (name ++) for ALL players on VisitorTeam

Score sheets works beautifully using Test data.


I receive Entire Season Schedule where each record (access 2007 table) supplies me:

Week number (1-15)
PlayDay (Mon,Tue...Fri)
PlayTime (AM/MidDay/PM)
PlayingField (1-6)
HomeTeam (by TeamID)
VisitorTeam (by TeamID)

I have VBA coding, which appears to be working properly, identifying
if input record has 1 or more scheduled games but I need help with:
..Getting all the player info for a given game from Team file
..Writing multiple records (where each record represents one game) in a
table.

Any Suggestions/Helpful hints? Thanks...jnh