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 !!

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Sachin Mittal 2 on at

Like (0)

Report
Copy link

Link copied!

can it be done without using event handler ??

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Thanks,

Girish S.

Was this reply helpful? Yes No