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!
