SELECT (IIF(ISNULL(FFTRACK.DESCRI_FR), FFFOLLOW.DESCR_FR, ; FFTRACK.DESCRI_FR)) AS DESCR_FR, ; (IIF(ISNULL(FFTRACK.ORDER_COMPLETED), "N", FFTRACK.ORDER_COMPLETED)) AS ; ORDER_COMPLETED; From fffollow ; LEFT OUTER JOIN fftrack on fffollow.ident = fftrack.ident_fffollow ; WHERE FFTRACK.CONSOLID = THISFORM.consolid AND; FFTRACK.IDFILE = thisform.fileid; INTO CURSOR cur_fffollow READWRITEI think that this solved your problem.