A surrogate key will mean changing all the tables fields that refer to Users, which is a suicide duty. There's too many data and too many tables. But I'll take...

No, I'm afraid that a surrogate key wouldn't solve the problem. I'll test the first option and tell you the results 🙂

Ok. I was able to create the two foreign keys, but: what if the ID (primary key) from the user changes (say, from tmosby to tedmosby)? I need all the...

Sorry John, I found the bug. I did the second foreign key with a different column. Instead of Modified_by_Users I used another one called Manager_users, which also refer to the...

This is what I get:

FK_Companies_UsersCompanies2012-03-07 14:11:14.8572012-03-07 14:11:14.857

So, this seem to confirm that there's already one foreign key pointing from Users (ID) to Companies (Created_by_user). But now, I need to create...

This is the statement I wrote in the query for the second foreign key (The first, Created_By_User, was already created in the database as you can see in the code...

If...

Could I write something like this?

ALTER TABLE [dbo].[Companies] WITH CHECK ADD CONSTRAINT [FK_Companies_Users] FOREIGN KEY([>Created By Users Name], [>Modified By Users Name])

REFERENCES [dbo].[Users] ([ID])

ON UPDATE CASCADE

ON DELETE CASCADE

Thanks.

Companies:

USE [CRM]

GO

/****** Object: Table [dbo].[Companies] Script Date: 03/07/2012 12:07:01 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Companies](

[ID] [nvarchar](255) NOT NULL,

[Date Creation] [datetime] NULL,

[Date Modification] [datetime] NULL,

[>Created By...

I haven't used triggers to do this. I just built it on the diagram of the database. As I said before, i know very little of programming, so I use...