I have a report that pulls data from two tables, both tables are linked by one field. The majority of the report pulls data from the first table. There are a handful of records that require lookup of data from the linked second table. My problem is that by linking the tables, it seems the report only lists the records that contain linked data on the second table. If I remove the links, all the records display as they should but without any data from the linked table.  How do I link tables and make it optional so that any records from the first table that do not have data on the linked table still display on the report.  I have a field that draws from the linked table and it displays the right info when the tables are linked but the report then omits all records that do not have a corresponding row in the linked table. I played with the LINK OPTIONS but that didnt help much. I hope I was clear in describing my problem.