Thanks for your help, I'll keep on with this method of making numeric autonumber IDs instead of using things like people's names.

The reason the ContainerTypeID is in the contact different...

OK I have tried to take the advice given (thanks for giving it) and change the database table structure, I have linked the tables into MS Access and drawn the...

Thanks for your help.

The problem I have with using IDs as keys is the user will see the IDs instead of the text on the main forums and would not...

It doesn't seem to have the answer though that link.

It says "The series of cascading referential actions triggered by a single DELETE or UPDATE must form a tree that contains...

PS. If it helps, this is what the tables currently look like -

USE [Tracker]

GO

/****** Object: Table [dbo].[tblLocations] Script Date: 08/27/2012 16:46:34 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

THANK YOU SO MUCH!

I upgraded our company from Exchange Server and SQL 2000 to SQL 2005 and google apps and the database mail has been broken for a while.

Been tearing...