Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Why Can't I Add Se...
Finance | Project Operations, Human Resources, ...
Unanswered

Why Can't I Add Second Child Datasource in View ?

(0) ShareShare
ReportReport
Posted on by 00030000036294D5 115

Hi all, 

         I am working on a view. On top, I have SalesTable as parent datasource in my view. Inside it, I have SalesLine as child datasource. Inside SalesLine datasource, I have InventDim as second child datasource. 

According to my new requirement, I need to add MarkupTrans as new child datasource. I want to put it besides SalesLine datasource because I want to set its join with SalesTable, but AX won't allow me to do it. Can somebody tell why it is happeneing. 

Or is it OK to have MarkupTrans inside InventDim and make its relation with SalesTable instead of InventDim, will it work ?

  • Jeson Profile Picture
    Jeson 120 on at
    RE: Why Can't I Add Second Child Datasource in View ?

    Hi, i think you cant add more than 1 datasource on view, maybe try to construct it on a query and drag the query to the view.

  • 00030000036294D5 Profile Picture
    00030000036294D5 115 on at
    RE: Why Can't I Add Second Child Datasource in View ?

    I have seen an example in standard AX where a view has multiple datasources at same level but then I realized that actually on top there is a query attached as datasources and these multiple tables are attached inside the query datasource.

  • 00030000036294D5 Profile Picture
    00030000036294D5 115 on at
    RE: Why Can't I Add Second Child Datasource in View ?

    Martin, my view is not based on a view. I just have SalesTable in the datsource and inside it, I have other tables like SalesLine and InventDim.

    My view does not have any query attached to its datasource, rather my view is attached to a query as its datasource.

  • Martin Dráb Profile Picture
    Martin Dráb 231,852 Most Valuable Professional on at
    RE: Why Can't I Add Second Child Datasource in View ?

    Unfortunately I don't use AX 2012 anymore, therefore I can't test it there, but I'm pretty sure that it can be done. I don't know what is cause of your problem. Isn't your view based on an existing query?

    Anyway, let me try to convince you that it having multiple data sources at the same level is possible. You should be able to find standard views with such data source, which would prove that it's possible. For example, look at CustTableCube. Below is a screenshot from F&O, but I believe that this view exists in AX 2012 and I assume that it has a similar structure.

    pastedimage1655956703302v1.png

    Using InventDim as the parent data source doesn't make a good sense to me. You can try it if you want to know whether it would wokm but I wouldn't do that even if it's technical feasible.

  • 00030000036294D5 Profile Picture
    00030000036294D5 115 on at
    RE: Why Can't I Add Second Child Datasource in View ?

    Or is it OK to have MarkupTrans inside InventDim and make its relation with SalesTable instead of InventDim, will it work ? Martin please answer this one as well. I have done it this way, but in my class where the view fields are assigning values to the table, fields from MarkupTrans table are showing black values in debugger?

  • 00030000036294D5 Profile Picture
    00030000036294D5 115 on at
    RE: Why Can't I Add Second Child Datasource in View ?

    When I right click on datasource, it does not show me option 'add new datasource'. When I try to drag and drop the table, there appears a black circle over the datasource button. what do I do ?

  • Martin Dráb Profile Picture
    Martin Dráb 231,852 Most Valuable Professional on at
    RE: Why Can't I Add Second Child Datasource in View ?

    It should be possible, AFAIK. What does exactly happen when you try to add the data source?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,027 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,852 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans