Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Linking Form DataSource to two existing DataSources

Posted on by 120

I have a request to add GeneralJournalAccountEntry.Text to the BudgetAnalysisDimensionDetails form.  (GeneralJournalAccountEntry isn't currently a datasource on this form.)

I can add the GeneralJournalAccountEntry table to the form but there's a one to many relationship between GeneralJournalEntry (already a form datasource) and GeneralJournalAccountEntry.

I really need to add GeneralJournalAccountEntry to the form with two join conditions (on different datasources in the form):

GeneralJournalAccountEntry.GeneralJournalEntry = GeneralJournalEntry.RecId (already defined as a relationship between the two tables) AND

GeneralJournalAccountEntry.LedgerDimension = BudgetAnalysisDimensionDetailTemp.LedgerDimension

I don't know how to get the second join condition into the form? Or is there a better way to add GeneralJournalAccountEntry.Text to the BudgetAnalysisDimensionDetails form?

  • JackieMc Profile Picture
    JackieMc 120 on at
    RE: Linking Form DataSource to two existing DataSources

    Thank you so much.  I overrode the join on the init method.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    RE: Linking Form DataSource to two existing DataSources

    Hi JackieMc,

    You can override the standard join with help of x++ coding on the init method of the data source.

    An alternative would be using a display method for the Text field.

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,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans