I have a master/detail query and want to do a full join from two tables in the detail part:

SELECT R.COMMENTS
     , R.REPORTID
     , REPORT_REQUEST.STATUS
     , R.REPORTNUM
FROM REPORT R
FULL JOIN REPORT_REQUEST
ON R.KEY_VAL = REPORT_REQUEST.KEY_VAL

KeyLinksAutoDefine is checked and the KeyLinks value is

R.REPORTNUM

I can't seem to get the full join to work. If the MasterLinks is R.KEY_VAL=MASTER.KEY_VAL I get the entries in the REPORT table, if it is REPORT_REQUEST.KEY_VAL=MASTER.KEY_VAL I get the entries in REPORT_REQUEST table. How do I get both?

Thanks,

Bruce