Linking Form DataSource to two existing DataSources

(0) Share

Report

Posted on by JackieMc

122

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?

All responses (2)

Answers (1)

JackieMc 122 on at

Like (0)

Report

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 Cal... 294,145 Super User 2025 Season 1 on at

Like (0)

Report

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.