RECORD_TYPE FROM 3 SOURCES
Posted: Wed Aug 04, 2004 1:13 pm
HI
I have target FCT_JOB_EQUIPMENT WITH COULUM REC_TYPE THE STABLE IS SOURCED OUT OUT OF THREE 1)STG_JOB_EQUIPMENT2)STG_CUST_RETURN3)STG_JOB_RETURN IF THE SOURCE IS STG_JOB_SHIPMENT THEN INSERT "SHIPPED EQUIPMENT"
IF THE SOURCE IS STG_CUST_RETURN THEN INSERT RETURNED BY CUSTOMER
IF THE SOURCE IS STG_JOB_RETURN THEN INSERT RETURN RETURNED BY INSTALLER
ALL THE OTHER COULMS I AM USING STG_JOB_SHIPMENT AS SOURCE ON THIS COLUM REQ IS LIKE THIS IT WANTS THREE SOURCES PLZ ADVICE.
THANKS,
BOBBY
I have target FCT_JOB_EQUIPMENT WITH COULUM REC_TYPE THE STABLE IS SOURCED OUT OUT OF THREE 1)STG_JOB_EQUIPMENT2)STG_CUST_RETURN3)STG_JOB_RETURN IF THE SOURCE IS STG_JOB_SHIPMENT THEN INSERT "SHIPPED EQUIPMENT"
IF THE SOURCE IS STG_CUST_RETURN THEN INSERT RETURNED BY CUSTOMER
IF THE SOURCE IS STG_JOB_RETURN THEN INSERT RETURN RETURNED BY INSTALLER
ALL THE OTHER COULMS I AM USING STG_JOB_SHIPMENT AS SOURCE ON THIS COLUM REQ IS LIKE THIS IT WANTS THREE SOURCES PLZ ADVICE.
THANKS,
BOBBY