Duplicate Record Warning Before Save

Duplicate Record Warning Before Save

Old forum URL: forums.lhotka.net/forums/t/9362.aspx


Russ posted on Wednesday, August 11, 2010

I have a WPF app that allows users to add people into a SQL table. I would like the UI to warn the user when they are about to add a person who’s first and last name match that of an existing person record in the database. The UI should then allow the save to continue or be cancelled.

I have tried creating an async business rule but it is inefficient because it queries the database with each keystroke.

Is there a way to insert "Before Save" logic that runs when the user presses the Save key? Is there an elegant way to go about this or does the input form need to become more of an input wizard?

Copyright (c) Marimer LLC