February 4, 200916 yr 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?
February 4, 200916 yr Maybe this demo will help. Btw, don't match on Company Name, relate tables using IDs. CondValueList.fp7.zip
Create an account or sign in to comment