in the DEPOSITS table create 2 calculation fields:
check with calc: 1
cash with calc: 0
in the INCOME table create a calculation field:
type with calc: not IsEmpty ( CheckNumber )
Now go into the relationship graph and create a new occurrence of table INCOME, so to have:
INCOME1 , DEPOSITS and INCOME2 with these relationships:
Now you'll be able to show 2 portals with different results.
Thank you for your carefully illustrated reply. Pictures are always very helpful.
I think I will have to study this a bit in order to fully conprehend it. Again, THANK YOU!
UPDATE: That seems to do the job! Thanks! Question: are there any disadvantages to having multiple table occurrences?
Question: are there any disadvantages to having multiple table occurrences?
This is the way that relational databases work.