title: Relationship between GeneralJournalAccountEntry and LedgerJournalTrans_Project
body: <p>We are attempting to relate GL transactions <code>GeneralJournalAccountEntry</code> with their appropriate Project Category Id <code>LedgerJournalTrans_Project</code>, but are having a very difficult time relating the two tables.</p>
  
  <p>We can get there by this route:</p>
  
  <ul>
  <li>GeneralJournalAccountEntry.GeneralJournalEntry = GeneralJournalEntry.RecId (Many to 1)</li>
  <li>GeneralJournalEntry.SubLedgerVoucher = LedgerJournalTrans.Voucher (1 to Many)</li>
  <li>LedgerJournalTrans.RecId = LedgerJournalTrans_Project.RefRecId (1 to 1)</li>
  </ul>
  
  <p>But the individual leg of the transaction gets lost in the Many to 1 and 1 to Many relationships.  We understand the tables are from different "modules", but are hoping there is some way to connect the two without depending on something messy like transaction amount.</p>
  
  <p>Is this possible, or is there another way to accomplish our goal?</p>