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