bill1650 Posted April 7, 2011 Share Posted April 7, 2011 I am attaching a sample file to try and show what it is I am trying to accomplish. In the sample file I have 4 tables. Vendors, Products, PO and PO Line items. The goal is to have the product id list in the portal on the purchase order show only the products for the vendor the po is being created for and not all the products for all the vendors. Currently the popup menu list all the products from all the vendors. Any help getting this correct would be greatly appreciated. PO_test Copy.fp7.zip Link to comment Share on other sites More sharing options...
comment Posted April 7, 2011 Share Posted April 7, 2011 Like this? PO_test2.zip Link to comment Share on other sites More sharing options...
bill1650 Posted April 7, 2011 Author Share Posted April 7, 2011 Yes. That's exactly what I was trying to do. Thank you for the help. I'm going to study the relationship graph and see what I was doing wrong. Once again thank you. Link to comment Share on other sites More sharing options...
bill1650 Posted April 8, 2011 Author Share Posted April 8, 2011 After studying the file I realized what I actually need is to have the pop-up menu show the product type and then a second poop-up menu next to it that shows the products related to the vendor based on the type chosen in the first menu. I have been trying to figure it out for the last 2 hours how to get the relationship correct for the conditional value list but am confused now . Can you please help me. Thanks. PO_test2 Copy.fp7.zip Link to comment Share on other sites More sharing options...
comment Posted April 8, 2011 Share Posted April 8, 2011 It requires a different point of view: PO_test3.zip Note that this won't work with a new PO until the record is committed. I have added a script trigger to do so on selecting the vendor. Link to comment Share on other sites More sharing options...
bill1650 Posted April 8, 2011 Author Share Posted April 8, 2011 Thank you very much. I don't think I would have ever figured that out. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4767 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