AnsweredAssumed Answered

Filtering Value Lists

Question asked by Jason_Farnsworth on May 12, 2014
Latest reply on May 12, 2014 by erolst

I have hit a bit of a mental block on filtering value lists.

 

Below is a copy of the relationship between the two tables in question

 

What I am trying to do is produce a filtered by CTR (Contractor) value list for picking contacts to send a message to. When I get the drop down list all that I would like to see are the contacts related directly to that contractor.

 

With in the contacts I assigned a self relationship from contractor ID to contractor ID and then set up a global field that has the ID stored in it.

 

ValueList.PNG

I think at this point I have allowed myself to go in the wrong direction.

 

Any thoughts of suggestions would be greatly appreciated,

 

Best regards,

 

Jason Farnsworth

Midland, TX

Outcomes