Filter child lookup field based on non primary key field in parent

(0) Share

Report

Posted on by TomSmelser

1,570

Hello,

I have an entity scenario like this:

Entities: Product, Customer, CustomerProducts, CustomerPurchaseOrder, CustomerPurchaseOrderProducts. A customer purchase order only has products that are assigned to the customer.

When I am in a purchase order I have a subgrid of purchase order products. I want to add a new product to the purchase order but it has to come from the customer assigned products.

I know it can be done, but having trouble getting the product lookup on my purchase order products to only filter based on the parent customer products. The CustomerPurchaseOrderProducts entity doesn't have a customer field since it's linked to the purchase order. Currently when I am in the Purchase Order Product form the product lookup shows products of all customers. I need it to filter on the parent purchase order customer.

The navigation is like this:

Customer=>Purchase Order=>Purchase Order Products.

I hope that makes sense. Any advice?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Aiden Kaskela 19,696 on at

Like (0)

Report
Copy link

Link copied!

Hi Tom,

It would be a little work, but you can filter a lookup in a supported way by using the addCustomFilter method (details: msdn.microsoft.com/.../gg334266.aspx). You should be able to add a filter on products linked to the customer through the relationship, and add a filter so it limits results to just the one customer.

Hope this helps! I'd appreciate if you'd mark this as a Verified answer.

Thanks,

Aiden

Was this reply helpful? Yes No