Trying to create a purchase oreder

[bill1650]

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

[comment]

Like this?

PO_test2.zip

[bill1650]

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.

[bill1650]

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

[comment]

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.

[bill1650]

Thank you very much. I don't think I would have ever figured that out.