Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Cashflow Table


Recommended Posts

I'm trying to get my 'Cashflow Table' to display records from an 'Income Table' and an 'Outgoing Table'.

How can I set it up so that a 'Transaction Date' column will display dates of both 'Income' and 'Outgoing' in chronological order?

Thanks in advance for any suggestions.

Link to comment
Share on other sites

Creat third tabel with fields:

Date, Income, Outgoing. This tabel must contain the date of all year. Then creat relationship on Date to the other two tables-let it be A and B. Then your Income in the third table will be calculation as Sum(A::Amount) and Outgoing will be Sum(B::Amount). Find in this tabel may be slowly, at this case you can by script make Income and Outgoing fields in the third table static fields.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use