Newby here. I have an accounting DB. One table holds account names and has a key for each of those account records. The other is a table of transactions. The Transaction table has fields for transactions: Key, date, acct FROM, amt $ of transaction, and acct TO.
I just learned how to do Portals and it works well, but only when I do the fillowing:
I can create a relationship from the Acct Tbl key to the acct FROM field 'OR' I can create a relationship from the Acct Tbl key to the acct TO field and have the portal work but I can't get the portal to work when I develop a relationship to BOTH of the acct fields in the transaction table. I have to have the portal show the results of both of the fields. How do I do this? Please give me simple explanations I'm new and want to understand this.
TIA for your help,