My reasoning on this is that if you delete a category, it should delete the questions that belong to it, the answer that belong to those questions.

If there are completed_categories...

Sorry Noel. I misread. But i sent everything the last time.

Here is the script for all the tables. Thanks guys!

Use FAE

GO

CREATE TABLE FAE.dbo.Centers

(

 CenterID  tinyint         NOT NULL   IDENTITY   PRIMARY KEY,

 Center    varchar(30)     NOT...

CREATE TABLE FAE.dbo.EmployeeTests

(

 EmployeeTestID     int            NOT NULL  IDENTITY  PRIMARY

                                             KEY,

 TestID             tinyint        NOT NULL  FOREIGN KEY

                                             REFERENCES dbo.Tests

                                             ON DELETE CASCADE,

 EmpID              smallint       NOT NULL  FOREIGN KEY

                                            ...

Thanks guys and Noel!

I think i'm finally starting to understand the BOL. You can do a search and then click the contents tab and see all the related info in...

Gimli, he does seem to differentiate on this point.

( I had explained a little more but every now and them my info gets lost when i press post reply.)

Thanks very much Dylan!  I  have a lot to learn. I'm in the process of looking up info so i can understand deleted and inserted tables better.  Now i see,...

That was all it said on that page. And i do understand that a book for novices, like myself, tends to over simplify.

The statement, i quoted earlier, was the first...

I find that very interesting guys! My book MS SQL Server 2000 Bible says under Stored Procedures page 403: "Store procedures are compiled and the fastest possible means of executing...