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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Look up based on two d...
Microsoft Dynamics AX (Archived)
Unanswered

Look up based on two dataSources

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all,

In production control module,

I want to add lookup(RouteId) on route details form this is based on site Id from salesLine and Item mapped to the route version.

After that i want to count the available routes in the lookUp.

Please anyone suggest.

Thanks.

*This post is locked for comments

I have the same question (0)
  • krishna.rao@dax Profile Picture
    krishna.rao@dax 3,008 on at

    You can make use of Sysmultitable lookup or views.

    Look into below articles give you idea.

    community.dynamics.com/.../multi-table-lookups-sysmultitablelookup

    hellodax.com/.../lookup-using-view-example-x

    https://hellodax.com/2015/02/16/lookup-using-view-example-x/

  • Community Member Profile Picture
    Community Member on at

    Hi Krishna

    I want routeId only in the look up this is based on siteId and ItemId combination from sales Order Line i.e how to set in queryValue pls response.   AnyOne

  • krishna.rao@dax Profile Picture
    krishna.rao@dax 3,008 on at

    You need to find the relation between the tables, which you use in the lookup.

    Then you may link the tables in the query, how you want to show in the lookup.

    Kindly Make a note that some people, may not work in the very same your requirement.

    But the procedure is similar. If you explore your requirement in detail (table structure, AssosiatedLinkBetweenTables, small example), someone might help you.

  • Community Member Profile Picture
    Community Member on at

    Hi how to find number of available rows in the look up drop down.

  • krishna.rao@dax Profile Picture
    krishna.rao@dax 3,008 on at

    You may create a Computed View Columns & implement using systable lookup.

    daxmusings.codecrib.com/.../computed-view-columns-in-ax-2012.html

  • Community Member Profile Picture
    Community Member on at

    Hi

    How to automatically load the values in grid.

    i.e In a lookup i will select one value and load the grid.I didn't select the lookup that is automatically load the first value in the lookup to grid.

  • Community Member Profile Picture
    Community Member on at

    Hi anyone suggest please.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Pratik Bhosle Profile Picture

Pratik Bhosle 2

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans