I'm trying to prevent duplicate records from being created. I have an application object with two relevant fields that looks like this:
- Applicant (Lookup(User))
- School (Lookup(School__c))
I'd like to only allow 1 application per applicant per school. An applicant can apply only once to each school. The applicant can apply to many schools.
I'm struggling a bit on where to start. What's the best way to go about preventing a new record?
I've started looking into Duplicate Rules, but when I try to set matching criteria the two lookup fields are not available, although other custom fields are.
If that's not going to work, I'm guessing I'll have to look at Apex triggers.