Razzman Posted February 4, 2009 Share Posted February 4, 2009 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? Link to comment Share on other sites More sharing options...
bcooney Posted February 4, 2009 Share Posted February 4, 2009 Maybe this demo will help. Btw, don't match on Company Name, relate tables using IDs. CondValueList.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5560 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now