Robert,

SELECT Table1.*, Table2.* ;
    FROM Table1 FULL JOIN Table2 ON Table1.SomeKey = Table2.SomeKey ;
    ORDER BY SomeField

>>If you used SQL with a FULL JOIN for your report you could check for NULLs in the parent part of the record.
>Hi Cindy and yes I see the value of built-in referential integrity.
>Could you send me a small sample of code of how to use SQL with a FULL JOIN.