web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to get Lookup Valu...
Microsoft Dynamics AX (Archived)

How to get Lookup Values in AOT query range field in When Open Query

(0) ShareShare
ReportReport
Posted on by MUHAMMAD HAARIS 770

Hi All,

I have added few fields like Brand, Code, IMEI Number and Product Name in "TmpInventAge" temp Table and the same fields are already added in InventTable except Product Name. 

For this, When i open the AOT query "InventAgeDim", For Item Id lookup values coming correctly as well. For the same I need to Lookup for all other fields which are added by me. I have created EDT for those fields except Product Name.

How can i get lookup values for those fields?

Records are exists in InventTable for those fields.

Thanks and regards,

Haaris.

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 238,149 Most Valuable Professional on at

    You must tell AX where to find the values you want to see, which is done through table relations.

  • MUHAMMAD HAARIS Profile Picture
    MUHAMMAD HAARIS 770 on at

    Thanks Martin,

    I have given relation to that fields in Temp Table from InventTable. But not coming values in Lookup...!

  • Martin Dráb Profile Picture
    Martin Dráb 238,149 Most Valuable Professional on at

    Unfortunately I can't say what's wrong with your implementation without more details. Could you please give us a concrete example?

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#2
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#3
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans