Am i losing it??  I thought two column names were not possible in a table.

Am i right?

Gift,

Ok i will look into it, but you cant have two columns with the same name in the same table?

Sorry if i am being silly.

Gift,

CompanyID is in tblProcedure, CompanyID1 and CompanyID2.

John,

You have hit it on the button, that is exactly what i am trying to do.

But why cant i choose the "SET TO NULL" option, instead of "CASCADE DELETE"?  Surely...

here is the code to create the objects

SET

ANSI_NULLS ON

GO

SET

QUOTED_IDENTIFIER ON

i am using sql 2005.

It is because the CompanyID appears twice in tblProcedure??  It that why it wont let me do it?

I havent got the sql, as i am using Diagrams to create the relationships.

CompanyID is an identity field and primary key.

CompanyID1 maybe filled in, as may CompanyID2, but the fields...

Thanks for your help, but i have found out how to fix it now.

If anyone else has the problem, then include the following line of code after the AS keyword...

No probs, here is the error.

Com Error No. = -2146824584

Description = Operation is not allowed when the object is closed.

This refers to the line where i do "If Not (RS.EOF And RS.BOF)...