Post Author: tmitchell
CA Forum: Formula
Simple query listing shop order, part number, customer and due date. Shop orders have multiple steps, when limiting seach to one workcenter multiple responses listing same due date appear. Tables are linked through shop order number.
Report will list shop order XXXXXXX due date XXXXX multiple times with same date
Any way to limit to one response?
schedule.sd_order_num <= 43000(shop order #)
sord_det.sd_part_num
q_cust.cu_cust_name
schedule.sd_mach_code =MACHRFQ VMC
sord_ds.ss_due_date <= 2/28/2008