Hello. I need to create a business rule in a table where I have three fields called Lease Start, Lease End, and Email. This rule would show an error message whenever the Lease End overlaps with the Lease Start of another record with the same email in this same table.
Thing is, apparently It is not possible to create business rules that lookup other values in the same table. Is there a workaround for this case or is it really not doable?
Thanks!
Thanks for the tip, I looked it up and there's even a D365 extension for VS Code. Will definitely try it out.
Hello,
You can develop a plugin that will handle create/update of your record, perform checks, and throw an exception if overlap exists.