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,