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.