Add Part description to a forecast report

[jpachut]

I am creating a new report with forecast data, however I need the report to include a part description and there is no part description field name in the ff_mstr table. Can anyone suggest a code where I bring in the pt_descr1 for all part that equal ff_part = pt_part..

Currently using version 9.1c
QAD eb

Thanks,

 

[longhair]

you just have to make the link to the other table.

for example:
for each ff_mstr no-lock:
find first table_name (where pt_part is) where pt_part = ff_part no-lock no-error.
if available table_name then do:
temp_var = pt_descr1.
end.
end.

regards,
longhair

 

[jpachut]

:blush: Thanks Longhair I am new at this and this helped me a bunch.

Thanks again.