Used to help users avoid creating duplicate entries for a given entity, for example two members with the same personal identity number.
The control looks like a normal textbox but when its value is changed it calls the control's stored procedure, which can choose to show a prompt offering to forward the user to another menu item.
Called when the textbox's value is changed.
CREATE OR ALTER PROCEDURE dbo.PIN_TextboxWithRedirect @Value varchar(max) = NULL AS BEGIN DECLARE @PersonId int = (SELECT PersonId FROM Person WHERE PIN = @Value); IF @PersonId IS NULL RETURN; -- Not a duplicate. SELECT CONCAT( 'A person with PIN ', @Value, ' is already registered. Do you want to view the existing entry?' ) AS Prompt, 'View' AS OkButtonText, 123 AS ForwardMenuItemId, -- Passingfields. @PersonId AS PersonId; END