Skip to Content
0
Former Member
Jan 04, 2008 at 05:43 PM

Multiple query returns

18 Views

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