Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Lookup filter
Microsoft Dynamics AX (Archived)

Lookup filter

(0) ShareShare
ReportReport
Posted on by AX Ankit 60

Hello,

I need help on automated filter on lookup.

So here is the case. When I click on any "Customer Account" lookup say in "Sales order form" I can filter it by just typing some text in the field. If I type the customer name it filters the customers and show only those records in lookup which matches the text entered in the lookup field. How this can be done for any custom field?

I have a EDT "XY" and have used it as a primary key in a table "ABC" which has 2 fields "XY" and "Description". I have set the "Table reference" property on EDT to "ABC".

When I use this field in any form it is showing me the lookup of the data in table "ABC". But I want if I enter some value which matches the "Description" field of my table it should filter the record in lookup.

It is filtering the records fine if I  enter text matching to "XY" field but not for "Description".

 

*This post is locked for comments

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Lookup filter

    The fields which you refer to are using x++ lookup methods instead of normal automatic lookups that are based on table relation.

    On the calling form, you will find method called lookup either on the field control, or on the data source field. That method usually calls the actual lookup method which you will find on the corresponding table.

    When you examine those methods, you should be able to create similar lookups in your own fields. You can also google for x++ custom lookups.

  • AX Ankit Profile Picture
    AX Ankit 60 on at
    RE: Lookup filter

    Sohaib Ahmad - Thanks for your response but I believe I am looking for something different. I am attaching an image for your reference.

    In the below image, I entered value "High" and the dropdown was filtered with only those items for which "Item Name" matches to the text.

    2766.Item.png

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: Lookup filter

    following support article should be valid in MSDyn365fo as well.

    blogs.msdn.microsoft.com/.../using-the-new-keyword-search-option-to-create-sales-orders-in-dynamics-ax-2012-r3

    and a video

    www.youtube.com/watch;feature=youtu.be

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans