AnsweredAssumed Answered

Filtering Drop Down List

Question asked by user28271 on Jul 28, 2017
Latest reply on Jul 29, 2017 by philmodjunk

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?

 

Screen Shot 2017-07-28 at 4.57.27 PM.png

Outcomes