Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

Add data sources in form

Posted on by Microsoft Employee

Hello,

I have two data sources tab1 and tab2 that are not related. I add them in form. 

I want to display tab1.file1 and tab2.file2 in a grid of form. 

I use propreties "join source" and "link type" but display does not good.

I need help please.
  • Martin Dráb Profile Picture
    Martin Dráb 225,610 Super User on at
    RE: Add data sources in form

    You're saying that you want to show dimension groups unrelated to the other data shown in the grid, but it makes no sense to me. Also, the requirement "to allow data control" doesn't explain much either.

    I think it would make sense if you showed the dimension group related to product.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add data sources in form

    In fact, at the grid level we manage to display the fields of the data sources "InventTable" and "EcoResProduct" because they are linked.

    However, I want to add a field from the "EcoResStorageDimensiongroup" data source that is not linked to any of the other data sources.

    The object is to be able to display the Storage dimension groups to allow data control.

  • Martin Dráb Profile Picture
    Martin Dráb 225,610 Super User on at
    RE: Add data sources in form

    If the tables are not related, what is the point of trying to sjhow them in a single grid? It makes sense only if those tables contains related information.

    Then you need to join those tables, either with InnerJoin or OuterJoin.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans