Chart showing linked & filtered data

Discussion created by FredH on Feb 5, 2016
Latest reply on Feb 7, 2016 by FredH

Hi Experts,

I have 2 tables :

  • TableA with
    • __pkActivityID
    • ActivityName
  • TableB with
    • __pkTurnoverID
    • __fkActivityID
    • Year
    • Turnover

For each record in Table A, I have 20 records of Table B.  Each year being the turnover for the 20 past/future years for the linked activity.


Whilst being on a form linked to TableA, showing a record from TableA - i.e. with __pkActivityID = 1, I would like to show a line chart with the turnover for the current activity (__pkActivityID = 1) for all the years < X (i.e. 2020).

I did several tests using ExecuteSQL but none of them gave the expected results.


Could you tell me which syntax I should use to achieve this?


Thanks in advance for your input & time!
Kind regards,