Validation "exists:" but add a where clause?

[alpine hazel]

Is there any way with built in validation rules to check if an id exists in a table, but also check to see if another column = a value?

[alpine hazel]

Ah was hoping to be able to do it in the rules array but its unavoidable