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 :
Finance | Project Operations, Human Resources, ...
Answered

Can map be used as a datasource in the forms?

(0) ShareShare
ReportReport
Posted on by 290

I have a form which should show vendtrans or custtrans based on the menuDisplayItem I was checking that whether I can use custVendTrans map as datasource? actually I have tried it in one form but nothing is shown, however I searched about and see this post  Can i use maps insted of Table. According to the answers, It seems we can use map as datasource but only for showing data not editing.

Also there is a form named "CustVendInvoiceSettlement_IT" in which CustVendTrans is used. If It is possible to use then why no data are shown in my form?

I have the same question (0)
  • Verified answer
    Hossein.K Profile Picture
    6,648 on at

    Hi Nastaran :D,

    I do not think you can use a map directly as a datasource in a form, why you do not create temp table or (temp ds) to fill it?

  • Verified answer
    ergun sahin Profile Picture
    8,826 Moderator on at

    We were using it in 2009. It started crashing in 2012, I guess they released a fix later.

    support.microsoft.com/.../you-cannot-open-a-form-that-uses-a-map-as-a-data-source-in-microsoft-dynamics-ax- 2012-44731661-c4f0-d7ae-2235-4b0a9e44cbb7

    I'm not sure if it's available now or just a control loophole But don't think of the map as a view or table, its use is different. As the name suggests it's just a mapping. You have to fill it

  • Nastaran Profile Picture
    290 on at

    Hii Hossein, glad to see you :)

    you know I wanted to be sure about this option that I cannot use. honestly, it is question that why maps are used in some standard forms.

  • Verified answer
    huijij Profile Picture
    19,811 on at

    Hi Nastaran,

    Map cannot Instead of datasource for Map cannot store Value and can't synchronized with the database.

    but we can view the value in a different table through map, similar to a view. fot it has its Benefits:

    map-overview#benefits

    regards

  • Suggested answer
    Hossein.K Profile Picture
    6,648 on at

    Hi Nastaran,

    Maps are used to link tables. By creating a map, fields can be accessed in different tables if the fields are of similar types but have different names. For example, a class that implements functionality to process data in the tables. If these tables use identical names for the columns, you can reuse data processing classes.

    A Map object associates one value (the key) with another value. Both the key and value can be of any valid X++ type, including objects. The types of the key and value are specified in the declaration of the map. The way in which maps are implemented means that access to the values is very fast.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 663

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 439 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 337 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans