Hi
You can try something like this:
For each pt_mstr no-lock:
find first tr_hist where tr_part = pt_part and tr_type = 'RCT-PO' and tr_date >= (today - 730) no-lock no-error .
if not available tr_hist then
display pt_part pt_desc1
end .
____________________________________
Max Viskov
Senior Consultant, Implementation Services
MFG/PRO Toronto User Group Board Member
32Soft Inc., an Official QAD Subcontractor
Have an MFG/PRO question?
I will answer your questions for free at http://www.32soft.com/site/modules/newbb/viewforum.php?forum=5[FONT="][/FONT]