I am constantly struggling with getting drop down list to only display certain values. Everything I think I got it I hit a wall.
First off if there a way to get a list via an Execute SQL? If so I would love to learn how.
But Here is the best I can do to explain the problem.
Rate Card to Clients
Clients to Job
Job to Bill
Labor to Job by Job ID.
In the portal of all the related labor in billing I need a drop down list of only that clients rate card.
Rate card is 3 hops from the labor.
Can anyone help me map this drop down list?