***FIXXED*** Are your arrows linked?

[dave]

paste this into your SQL design view and you can see if all your arrows are linked properly.

SELECT First(PID_TOFR.NOTES) AS NOTES, First(TAG_REG.TAG_NO) AS [PROCESS TAG], First(PIPE_RUN.RUN_NAME) AS RUN_NAME, First(PID_TOFR.FLOW_DIR) AS FLOW_DIR, First(TAG_REG_1.TAG_NO) AS [MD PROCESS], First(DOC_REG.DOC_NAME) AS TAG_NO, First(DOC_REG_1.DOC_NAME) AS [MATCHED DRAWING], First(PIPE_RUN_1.RUN_NAME) AS [MD RUN], First(PIPE_RUN_1.PSZ) AS MDPSZ, First(PIPE_RUN.PSZ) AS PSZ, PID_TOFR.KEYTAG
FROM (((((((((((PID_TOFR LEFT JOIN PIPE_RUN ON PID_TOFR.RUN_ID = PIPE_RUN.KEYTAG) LEFT JOIN PROCESS ON PIPE_RUN.LINE_ID = PROCESS.KEYTAG) LEFT JOIN TAG_REG ON PROCESS.KEYTAG = TAG_REG.KEYTAG) LEFT JOIN KEY_LINK ON TAG_REG.KEYTAG = KEY_LINK.KEYTAG) LEFT JOIN PROC_LNK ON KEY_LINK.LINK_ID = PROC_LNK.LINK_ID) LEFT JOIN DOC_REG ON PROC_LNK.DWG_NAME = DOC_REG.DOC_ID) LEFT JOIN KEY_LINK AS KEY_LINK_1 ON PID_TOFR.MATCH_KEY = KEY_LINK_1.KEYTAG) LEFT JOIN PID_TLNK ON KEY_LINK_1.LINK_ID = PID_TLNK.LINK_ID) LEFT JOIN DOC_REG AS DOC_REG_1 ON PID_TLNK.DWG_NAME = DOC_REG_1.DOC_ID) LEFT JOIN PIPE_RUN AS PIPE_RUN_1 ON PID_TOFR.RUN_ID = PIPE_RUN_1.KEYTAG) LEFT JOIN PROCESS AS PROCESS_1 ON PIPE_RUN_1.LINE_ID = PROCESS_1.KEYTAG) LEFT JOIN TAG_REG AS TAG_REG_1 ON PROCESS_1.KEYTAG = TAG_REG_1.KEYTAG
GROUP BY PID_TOFR.KEYTAG;