Ensure Each Case Has an Assigned User

Your table should have a field that stores the username or user ID of the assigned person (e.g., AssignedTo). Get the Logged-in User If you're using Windows authentication, you can retrieve the current user's name.