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.