APEX

UPDATE

I have gotten this to work but I am not sure of its accuracy.

select null as link,
b.wt_data_dt as label,
(select BOM_WT from JAR_PRODUCTS a
   where a.jar_prod_id = b.jar_prod_id) as bom_wt
(select DECL_WT from JAR_PRODUCTS a
   where a.jar_prod_id = b.jar_prod_id) as decl_wt
from JAR_WEIGHT_DATA b

Soooo....

1. I need the ACT_SMPL_WT from JAR_WEIGHT_DATA and it doesn' t seem to like more than one table.  Should I create a view?
2. I'd like to increase the date range on the Y-axis

Any ideas?

Thanks in advance!

************************************

I have two tables:

JAR_PRODUCTS

JAR_PROD_ID (pk)

ITEMNO

ITEM_DESC

DECLARED_WT

BOM_WT

JAR_WT_DATA

WT_DATA_ID (pk)

JAR_PROD_ID (fk)

WT_DATA_DT

ACTUAL_WT

UPDATE - I FORGOT THE MOST IMPORTATNT PART.

Need to graph DECLARED_WT, BOM_WT, AND ACTUAL_WT by WT_DATA_DT

I can't figure out the syntax to create a multiple series line chart.

Y-Axis: Ounces

X-Axis: Date

I have looked at many examples but am unable to get it to work.

Thanks in advance for some tips!

Alexandra