AnsweredAssumed Answered

SQL request stored procedure parameter

Question asked by bbartlett on Nov 8, 2017
Latest reply on Dec 18, 2017 by fhunth

Is it possible to base a SQL Store Procedure parameter off of another SQL request drop down selection on the same form? 

 

I have one field 'Pay Location'' that is a SQL request drop down. Once a value is selected I am hoping to use this value for a @PayLocation parameter located in another stored procedure that is being used on another SQL request drop down that will then show all Employees who's pay location = @PayLocation. 

 

Attached is a screenshot of the configured parameter for the stored procedure. 

Outcomes