Creating line items based on vendor

Discussion created by bablackburn on Feb 22, 2018
Latest reply on Mar 1, 2018 by bablackburn

In my solution I have a portal that needs to display a list of line items for a particular order. These line items are grabbed from a vendor's list which is stored in a separate table. I have gotten this same operation to work for choosing a suppliers specific location (as each vendor may have several different locations) but I can't seem to get it to work for the products that vendor sells.


The idea would be to click the item field and select the item from a drop down list and then have the relevant data such as cost and unit of measure be a looked up value. As it stands now I can get all possible values to show (every product from every vendor) but when I try to show only related values (items that are specific to that vendor) I get no results back.


Screen Shot 2018-02-22 at 9.49.26 AM.png

Screen Shot 2018-02-22 at 9.50.00 AM.png

Screen Shot 2018-02-22 at 9.53.24 AM.png

Screen Shot 2018-02-22 at 9.50.49 AM.png