I need to **record** all **previous addresses and postcodes** when they are updated in the Customer table.

**Business requirement: Addresses cannot be changed without also updating the postcode and vice versa.**

A mechanism to prevent this is required along with appropriate **error messages.**

I already created the table:

```
create table tblCustomerAudit
(
CustomerID int identity(1,1) not null,
CustomerName nvarchar(255) null,
CustomerAddress nvarchar(255) null,
CustomerPostcode nvarchar(255) null,
CardNumber nvarchar(255) null,
)
go

alter table tblCustomerAudit
add constraint FK_CustomerAudit
foreign key(CustomerID)
references CstmrEng.tblCustomer(CustomerID)

```

What would trigger look like? please help!