Auto create multiple records, but change one dynamic value each time?

[BrackAttack]

Hello!

I am learning filemaker as I work on a database and would appreciate some guidance.

I have a master members table (as primary key)

I have a master games table (as primary key)

I have the tournament date table (as primary key)

I have a scores table (as foreign key: date, member, & game)

So, when I create a new tournament record, I then assign a subset of games to play on that day.

Then, a subset of members joins that tournament.

Each time a member joins the tournament, I have to create a new score record for each game...usually up to 7 games.

Is there a clever way to assign a member to the tournament, and automatically create a score record for each game associated with that tournament? (other than my brute force method?)

...Or am I even approaching this right?, as I "assign" a member to the tournament by creating these score records for each game.

Thank you.