I'm using Dynamic Forms to create a login screen that points to an external SQL user table - nothing to do with DNN users.  I've got a User Name and Password textbox along with a submit button and a hidden UserID field.  I've got the Validation SQL query working nicely to check the entry.  My question is, how do I get the UserID of the logged in user (coming back from some SQL query) into the UserID hidden field before the page is redirected.  Is there any other way to pass this UserID on?  Where do I perform this UserID SQL query?

I guess my main problem is knowing where to put the SQL query that returns the UserID.  The Validation Query only returns the value for validation so it doesn't look like I can return a UserID there.  It doesn't look like I can write a SELECT query in the Completion Events section to return the UserID.  Where does my SQL query go that can be fired after the submit button is clicked?

Since I'm not using any of the DNN user information (pulling all of it out of a different database), $(UserID) won't have a value I'm looking for.

If a use a default value SQL query for the hidden field, my SQL statement needs to look something like: but where do I get @Lastname from if it hasn't been filled in yet. I need this query to fire after the submit button is activated on this form.

SELECT ClientID FROM [server].[database].dbo.Users
WHERE MTLastName = @LastName AND MTFirstName = @FirstName AND Password = @Password