Do you have data-bridge? That would allow you to add actual unique record validation with the server validations server behavior. Otherwise I'd probably do a manual check by adding a recordset to see if the record already exists before doing the insert and using that to display an error message when applicable.