Dynamic chart using two recordsets

[hbibizadeh396670]

Hi

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

[Jason Byrnes]

the wizard will only be able to use one table, but you can edit the recordset that is created after the wizard creates the pages and use a join query to get the data from the second table.

if you need help with this, post a copy of your page and the DynamicWebCharts/data folder.

I will need screen shots showing the schema for these two tables.

[hbibizadeh396670]

Hi,

Thank you for your help.

I managed to sort it out.

Thanks again

[Jason Byrnes]

glad to hear you have it working.