Enforce uniqueness without table extension and index

(0) Share

Report

Posted on by TheGoodDBA

235

Hello,

I have a development requirement for D365 F&O on the SalesCreateOrder form. When order entry occurs, they would like to enforce that the same customer account (SalesTable.Custaccount) does not use the same customer requisition (SalesTable.PurchOrderFormNum) in the system. My solution is to have a formDataFieldEventHandler on the PurchOrderFormNum and check for duplicates OnValidating. This works fine, but it does not enforce the duplicate from being written. I can do the same thing on FormDataSourceEventHandler, OnValidatingWrite but again, it's not enforcing the write. I was about to create a table extension with an index to enforce the uniqueness on Custaccount and PurchOrderFormNum, but Microsoft warns this will not be supported in future releases.

What can I do to enforce that the form will not allow the write?

Thanks,

Steve

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report

You're claiming that you want to enforce writing, but I think you want the oposite: to prevent the record from being saved to database.

If your code in the event handler of OnValidating doesn't do this job, the likely explanation is that you forgot to set the validation result to false. Please review your code and share it with us if needed.

Was this reply helpful? Yes No
Suggested answer

TheGoodDBA 235 on at

Like (0)

Report

That was it exactly.

Thank you for the suggestion.

Steve

Was this reply helpful? Yes No