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?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
JackieMc 122 on at

Like (0)

Report

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

Was this reply helpful? Yes No