Hi All,

I have a custom objects called Deal__c ,Document_Type__c,Uploaded_Documents__c . 

Uploaded_Documents__c has a lookup relationship to Deal__c 

Uploaded_Documents__c  has  a lookup relationship to Document_Type__c

Content (Standard object) has lookup to Deal__c

Content (standard object) has lookup to Document_Type__c.

There a visualforce page(custom link from Deal__c)  where they upload the document.There is another visualforce page basicially has the checklist of documents(document type) (custom link from Deal__c) which shows the list of  documents that got uploaded and also the list of documents which needs to be uploaded to close the deal

On insert of document there is trigger on Deal__c which creates Uploaded_Documents__c record for each insert of the record.

The issue is  if there is any update of document type  like deleting the document type (means removing from the document checklist) will remove the correspoding link to 2nd visualforce page.

We don't want to affect the deals that already has some document uploaded.we just want to affect the deals for newly created ones.

I need some help on how to handle document type think just like checklist of document types which gets changed frequently.