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.



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