Hi,

I have created a query table linking two tables and that all works fine.

When I create a chart or edit an existing one created automatically, not all the fields on the query table are available as a filter.

I cant see an obvious reason for the fields not being available.

The SQL for the query table is:

SELECT "Due Date","Pharmacy Group Name","Total","VAT","Invoice Paid","Paid Date"
FROM "Invoice Items"
JOIN "Invoices" ON Invoices."ID" = "Invoice Items"."Invoice ID"