I am trying to create multiple one to many records from a button on a form. The form displays data from a "bowlers" table. I need to take he PK from the bowler and create records in another table to represent fees owed by week. I have a table with the dates in it that I need added to the form. What I am looking to create is records in my table like this:
bowlerid, weekno, teamno, house, bowlertype, owedamt.
I have two types of bowlers, regular and sub. The code needs to look at the table first and determine if the bowlerid is already in the table..if not in table then look at bowler type and determine regular or sub. If regular need to create records for weekno 1-17 and add in the rest of the infor from the bowlers table along with a specific "owedamt".
I can not figure out how to add the multiple values while doing the loop for the 17 weeks. I have over 200 bowers and need to create the charges in the table upfront at one time for each bowler.
Any help is greatly appreciated.
bowlerid, weekno, teamno, house, bowlertype, owedamt.
I have two types of bowlers, regular and sub. The code needs to look at the table first and determine if the bowlerid is already in the table..if not in table then look at bowler type and determine regular or sub. If regular need to create records for weekno 1-17 and add in the rest of the infor from the bowlers table along with a specific "owedamt".
I can not figure out how to add the multiple values while doing the loop for the 17 weeks. I have over 200 bowers and need to create the charges in the table upfront at one time for each bowler.
Any help is greatly appreciated.