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.