News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) N:N Inline Look Up Sea...

Microsoft Dynamics CRM (Archived)

N:N Inline Look Up Search Showing both Active and In Active records

(0) Share

Report

Report

Posted on by Balaji Karpurapu

187

Hi,

I have placed N:N subgrid on Entity Form and When i try to search with name in N:N subgrid inline lookup search it's showing all Active and Inactive records of the name. I need to show only Active Records. Please refer attached screenshot. I searched with "AL" as below

3157.Capture.PNG

After click on enter it's displaying both Active and Inactive records. Can we show only Active record only??

3157.Capture.PNG

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

BJMcmullan 720 on at

Like (0)

Report

RE: N:N Inline Look Up Search Showing both Active and In Active records

Update the Filter Criteria of the Entity Lookup View (ex. Account Lookup View) to have Status Equals Active. That will pre-filter the dataset for your search.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2

Martin Dráb 231,305 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans