Based on lookup value filter another lookup

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi everyone!

I have this scenario.

An entity Supplier supplies different types of products , another entity Types.

So Supplier1 supplies Screens, Mouses, PCS

Supplier2 supplies Mouses, Keyboards

etc.

I have two lookup fields that lookup to these two entites. Ideally i would like the lookup for Types to be filtered based on Supplier. Now i tried to do it with Dependent Lookups and thing is , if a Type is related to two Suppliers i will need to create two identical Types that lookup to two different Suppliers . What should be done is the Supplier to have a grid with multiple types , and based on the Supplier value on the form, to show the related Types from the grid on the Type lookup field . I will have to use it for deeper levels next , so Types should have Brands below etc.

Is there a way to do it?

Thanks!

*This post is locked for comments

All responses (2)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Based on lookup value filter another lookup

Dependent lookups will work EVEN for N:N relationships. I thought this wasn't possible but it is so problem solved
Suggested answer

Nithya Gopinath 17,074 on at

Like (0)

Report

RE: Based on lookup value filter another lookup

Hi Shak,

Have you referred the following community thread?

community.dynamics.com/.../159418

Hope this helps you.