Finance | Project Operations, Human Resources, ...

Filter Lookup Based on Another lookup Value selection , help !!

(0) Share

Report

Posted on by Sachin Mittal

here category is child under subsegment, but in category lookup, values where subsegment is ABC only should show up , as ABC is selected for subsegment Id above it , but category is also showing (AbCD , sub3) subsegment fields data ( thats should not come here ). relations are also properly defined

Thank you !!

All responses (3)

Answers (0)

GirishS 27,821 Super User 2024 Season 1 on at

Like (0)

Report

RE: Filter Lookup Based on Another lookup Value selection , help !!

No, you need to override an lookup event handler method to achieve this.

Thanks,

Girish S.
Sachin Mittal on at

Like (0)

Report

RE: Filter Lookup Based on Another lookup Value selection , help !!

can it be done without using event handler ??
Suggested answer

GirishS 27,821 Super User 2024 Season 1 on at

Like (0)

Report

RE: Filter Lookup Based on Another lookup Value selection , help !!

Hi sachin mittal,

You need to override the lookup event handler to filter values. Based on the selection of Subsegment you can filter category lookup.

Copy the lookup event handler of category control and paste it in the new class. Add code for lookup and also add range to it.

Refer to the below blog which might help you.

https://community.dynamics.com/365/financeandoperations/b/dynamics-365-fin-ops-technical-help/posts/applying-range-on-the-lookup-based-on-the-selection-of-value-on-other-field-x

Thanks,

Girish S.