Conditional customer value list

[Razzman]

2 DB's (Customer List and Active Projects). I have set a relationship to Company-Company and Project Manager-Project Manager. In the Active Project DB, I wish to view the name of the company and specific project manager's name. Not a problem with the company. I set a Value List and it looks up all of the Companies back in "Customers". Same with the Project Managers, however, it shows everyone's name. How can I set this up, that once I set the Company, the only persons that appear in my Project Manager field are one specific just to that company, and not every person?

[bcooney]

Maybe this demo will help. Btw, don't match on Company Name, relate tables using IDs.

CondValueList.fp7.zip