AnsweredAssumed Answered

Filtering Drop Down

Question asked by user28271 on Feb 5, 2018
Latest reply on Feb 5, 2018 by philmodjunk

I have struggled with the architecture for a drop down with a "Show Include Related Values from."  I call this a filtered drop down.  But I have a process that works.

 

But now I have a more complex requirement.

 

Table:            Labor

Key Field:     Client ID

Key Field:     Class

 

Table:          Client

Key Field:     Client ID

 

Table          Rate Card

Key Field     Client ID

Key Field     Class

 

In labor I want a dropdown to select the Rate Card that matches Client ID and Class.

 

I can get a drop down of all the rate card records that match the client.

 

I can't figure out how to get only the rate card records that match Client and Class.

Outcomes