Line graph

[#1]

Hello,

I need to make a line graph that has the following characteristics:

I need to show these values on x-axis: (0, 20, 40, …, 120) and these value on y-axis: (0, 200, 400, … ,1400).

I have 2 tables in my database which look like this:

Table A with 1 column: ANumber int (PK)

Table B with 3 columns: BPrimaryKey int (PK)

ANumber int (FK)

BValue int

Each ANumber has a set of values in table B which are kept in BValue column. I want to make a line graph for each of these sets. And I like to show all the lines in one graph not in separate graphs.

I appreciate any kind of help with this [:)]

Thank you very much,

Naeemeh

[johnw]

First dimension: ANumber
Second dimension: Whatever your X-axis is supposed to be (BPrimaryKey???)
Expression: Whatever your Y-axis is supposed to be (BValue??? sum(BValue)???)