Unanswered: Joining tables with possible null foreign key
I'm running a report (using CR8.5) that shows daily activities of our employees from our DAILY table. The DAILY entries have a foreign key to our FACILITY table, which is sometimes null . I'd like to show all the daily entries with some facility info from those associated with a facility, but as soon as I link DAILY to FACILITY, my report loses all entries with a null in the DAILY."FACILITY_ID" field.
Is there someway I can straighten this out within CR?