AnsweredAssumed Answered

Additional help with the Sql Control

Question asked by brianknight on May 18, 2018
Latest reply on May 22, 2018 by brianknight

I have a question regarding the sql control.  Is it possible to display the unduplicated list of potential choices.  Let me show you what I’m talking about.  This is the returned value set returned from a sql query

We have several Pay schedules each with multiple steps (I know only government can create such a goofy system).  The database looks like this:

Is there a way to just limit the view to do the following?

My control is setup is this

Ultimately, I'll need to limit the Step query to list the steps based on what was selected in this control.  From there I can capture the rate to determine what the salary will be.  Eric Harris

Outcomes