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