Hi Guys,
I have a form & table called CommissionTrans where I have the dropdown field settlementId. I need to select the SettlementId for each transactions manually on this form . I have to add a validation that I should be able to select one settlementId for one transaction only. If I select the same ID for next transaction it should show an error that its already used for another transaction. how can I do it ? which validation method to be added and how the code should be.
*This post is locked for comments