Forecast Data Only

[jpachut]

hello!

I am wondering if anyone can help me! I am trying to get the forecast budget data only from our budget file and this is the code I am using but it seems like it is bringing in budget data from everywhere...
I need the part number from the ff_mstr to be equal to the pt_mstr and to the ro_det tables. I have to have the part description from the pt_mstr and I need routing information from the ro_det table..
Can anyone please help me find out what I am going wrong..

using EB version 9.1c


[FONT=r_ansi]for each ff_mstr where,
/* ff_date >= ro_start and ff_date <= ro_end no-lock, */
each pt_mstr where pt_part = ff_part no-lock,
each ro_det where ro_routing = ff_part
and ((ro_end = ? and ro_start = ?) or
(ro_start <= today and ro_end >= today) or
(ro_start <= today and ro_end = ?) or
(ro_start = ? and ro_end >= today)) and
(ro_wkctr >= ws-from-cell and ro_wkctr <= ws-thru-cell) no-lock
break by ro_wkctr by ff_part:
[/FONT]

 

[longhair]

jpachut,
morning.
you need something in your for each to indicate that you only want forcast data. is there a field in your table that indicates this? something special about another field in the table that you can key off of? another table that indicates what ff_mstr is forecast?
regards,
longhair