Hello, thanks for your reply.

When I add a new product in my accounting software and select Save & Close, I want a custom field (ZDateopened) in the database to be...

I re-booted my PC hoping this would fix the issue and it has not.

Can't understand why this is so difficult...

I feel like such a pain - I ran the script in SQL and was ok.

Tested a transaction in my system and now get this error.:

Microsoft ODBC SQL Server Driver...

No it should be AccountID

Well I've checked all the crystal reports written which come with the software and they all link as:

Customers.UniqueID > Transheaders.AccountID

So I would assume yes.

Ok.. so what should I do?

Ok ...

Customers

USE [EvaluationCompany7AU]

GO

/****** Object: Table [dbo].[CUSTOMERS] Script Date: 05/11/2014 20:00:02 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[CUSTOMERS](

[UserLockNo] [int] NULL,

[CompanyID] [char](11) NOT NULL,

[UniqueID] [char](17) NOT...

The transheaders table contains the TradingDate which is (datetime,null)

The Customers table contains the column ZLastSale which is (text,null)

I don't know what version of SQL the Programmers used to create those tables. Is there a way of finding out?

I'm using SQL Server 2008 R2 Express

Sorry - I'm confused now and not following. Thanks anyway.

I'm using SQL Server 2008 R2.

Thank You.

I ran the script and it worked fine.

When I test the transaction in my system I am getting this error:

Microsoft ODBC SQL Driver SQL Server Conversion failed when converting...

The correct name is ZLastDate.

If a new transaction for a particular Customer is entered then the Transheaders table should fire the Trigger and update only that Customers record. (As in...

Wow, that looks complicated!

I didn't write my script I had it provided to me.

I am new to Triggers, so that script really means nothing to me.

Are you able to assist...