Dynamic chart using two recordsets
I have made a directory.
I want to make a dynamic chart that shows the categories and the number of listings per category.
However, I have set up my directory so that I have two database files/tables. One for category and another for the listings.
I need to use two recordsets to make the chart, but in the dynamic charts interface I am not sure if it will allow me to do this.
Could you please conform if this is possible or not?
Thank you in advance