I am the only user manipulating the form, there are no triggers on the view bound to the form - just an instead of delete trigger in 2 of the...

I think it is very normal to copy an entire record given I just want to change the name of the unique-constraint column instead of having to insert all the...

I am able to insert normally.

Only in case of copy/paste , the hash deleted happens if not all values are supplied for all the columns of the pasted record.

Ok , I understand

But what about the hash deleted . Any explanation and workaround ?

At first I thought it is because a record is inserted and the view wasn't refreshed...

Well actually it's just that a user first attempts to copy a record then add the values they desire , but SQL won't be patient enough and will display a...

I am inserting duplicate values in a unique column on copy-paste.

I actually copy paste and then I display the message of duplicate value then make that column have a non-duplicate...

Linked to SQL Server 2012 view

That is , do something about this part

Select c.CultureID,c.WeekNr FROM (SELECT CultureID,MIN(CultureStepID) CSS

...

I got help from one of the forums to write the statement in access and after a little modification it slowly works as follow:

SELECT some columns

FROM (Trial LEFT JOIN...

The main problem which made me think of detaching from views is that update cannot be done (getting database exception : modification affects multiple base tables)

Alright thank you both...I should seriously consider

Oh, an important question regarding the join

I learnt about using CTE instead of a view so that I can do it all as sql queries

However , adding the With part...

Thank you ...

But with so limited time , what can I do to help me go through until I can have more time to read the book(s) you suggested and...

Thank you for the excellent post .

Can you please help me become capable of doing such analysis?

How were you able to make the simplified ERD and come up with the...

Culture

CREATE TABLE [dbo].[Culture](

[cultureID] [int] IDENTITY(1,1) NOT NULL,

[CultureName] [nvarchar](50) NOT NULL,

[Process] [nvarchar](50) NULL,

[Cropspecialist] [nvarchar](50) NULL,

[Requestor] [nvarchar](50) NULL,

[CuttingsOrSeed] [nvarchar](50) NULL,

[EndLocation] [nvarchar](50) NULL,

[StartWeek] [int] NULL,

[StartWeekDeviation] [int] NULL,

[DeliveryWeek] [int] NULL,

[DeliveryWeekDeviation] [int] NULL,

[Purpose] [nvarchar](50) NULL,

[Crop]...