2. ASPRunnerPro General questions
  3. Add multiples to same table
This topic is locked

Add multiples to same table

 		1/30/2008 5:27:45 PM
ASPRunnerPro General questions
A
 ashumak author

Hi,
Trying to allow entry for teams into a league database. I have tables for team, manager, coaches and players. I need to allow input all at once (one page) for 3 coaches and 13 players on any one team. Any suggestions on how to do this with ASP runner?
J
 		Jane 1/31/2008

Alan,
you can create new table with all these fields (for 3 coaches and 13 players).

Then parse all entered values in the Before record added event and save these values in different tables (coaches and players).
A
 		ashumak author 3/1/2008

Alan,

you can create new table with all these fields (for 3 coaches and 13 players).

Then parse all entered values in the Before record added event and save these values in different tables (coaches and players).


Sorry for missing this, but my email had to be changed. I have now set it up as a team table (basic taeam info), a managers table, with fields for Manag, coach1, coach2, and coach3) and a players table.
Should the players tabel be with fields for 13 different players(player1, player 2) or just for all players?
And then what do I do? Parse???Sorry, not the greatest when it comes to techno speak at times.
J
 		Jane 3/7/2008

Alan,
generally it's not possible to add records to more then two tables at the same time.

As workaround you can create one big table with all fields from all tables, then construct queries for team, managers and players tables in the Before record added event and insert data to these tables separately.

You should be familiar with ASP and SQL for that.
As more easy way I recommend to add data separately.

For example add data to the team table and redirect to managers add page. To redirect use After record added event -> Redirect to another page action on the Events tab.