User Input For Multiple Row Database Entry

Hello! I have a project I am trying to do where a coach can enter his teams roster where it’s:
Name: Position: Number:
Name: Position: Number:
Name: Position: Number:
Name: Position: Number:
Name: Position: Number:

I want them to be able to submit this and it creates a new row in the database for each player if that makes sense. I currently have one database for the team roster. Any help would be awesome! Thanks.

Hi Brandon,

Are there five, and only five, roster “spots”?

If so, that could be done with a little coding.

If not, it would be simpler to have a form that had just the three fields: name, position, and number, and just keep adding the records with a button click.

There would be an unknown amount of players as in, each team might have a different amount.