Inserting to Multiple tables

Results 1 to 2 of 2

Thread: Inserting to Multiple tables

  1. #1
    Chris T Guest

    Default Inserting to Multiple tables

    Hi all,<BR><BR>I&#039;m wanting to insert records from 5 forms on a page into 5 seperate tables.<BR><BR>The application I am building is a courses database for a University. I want to create an Admin page where users can add new courses. The main table is a course info table (PK CourseID) and there are 4 related tables, Year1, year2, year3 and Year4 each of these tables can hold multiple records for each course and have (FK courseID). <BR><BR>I am using SQL server & Ultradev at the moment but realise that Ultradev is very limited and I will probably have to create a stored Procedure.<BR><BR>Can anyone help or suggest a resource for tutorials on this sort of thing?<BR><BR>Thanx in advance <BR><BR>CeeTee

  2. #2
    Join Date
    Dec 1969

    Default RE: Inserting to Multiple tables

    For starters, you may want to reorganize your tables:<BR>Consolidate the Year tables into one table, using a "year" field to specify 1, 2, 3, 4<BR><BR>check out:<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts