Uploading the latest date from related table

Discussion created by barcello on Jun 8, 2014
Latest reply on Jun 13, 2014 by barcello

Hi everybody,

I have two tables:

  • checking account
  • bank balance.

In the first one I stored all the details of my company’s accounts (including the balance using a relationship) and in the second I store the monthly balance (every end of the month).

Now, I would like to show in the report, based on the checking account table, always the latest bank balance from the second table. It means that every time I open the report I need to see, within all my info also the last month balance.


Thank you