In the view shown below, SO# is the PK (not auto generated). In the image, I have attempted to add a new record with the same PK (10724) as another record, understanding that it should throw an error, which it did.
Question 1: Is there a way I can change the text? I would like it to say, for this view) “There is already a project with SO ‘10724’. Please enter a unique SO” or somethng along those lines.
Question 2: Is there a way that I can trigger/offer a secondary action when this happens? Example, since there is an existing record, I would like to offer the option to jump to the details view for that record.