Unique Field on CustInvoiceLineTemplate

(0) Share

Report

Posted on by capedcrusader

I have created a Custom field called /RID/ on the CustInvoiceLineTemplate Table, I want this field to be unique and not allow duplicates. I have created an index for this table with the RID field, yet it still allows duplicates, is there a way I can go about ti

All responses (2)

Answers (0)

capedcrusader 31 on at

Like (0)

Report

Unique Field on CustInvoiceLineTemplate

I had done this but the field still allows duplicate records
Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

Unique Field on CustInvoiceLineTemplate

Hi,

That can be achieved by adding an index to the table. Just add the field/s that make up the key, and set the property Allow duplicates to No for that key. You can refer to this thread: www.dynamicsuser.net.

Best regards,

Kevin