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?
