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.
