I have a report that displays open orders by customer. I need to display the information about the order including the "Bill to" and "Ship to" names. Everything is contained in one table with the exception of the "Ship To". The "Ship To" is contained in a second table.

The problem is that not every order has a record in the second "Ship to" table. The only orders with records in that table are the ones where the programmed "Ship To" has been overridden while entering the order (drop shipments).

When an order does not have a record in both files, I'm getting duplicated records. I can suppress the duplicates, but that creates other problems, particularly with summarizing totals. I have experimented with different link types, but that doesn't seem to be making a difference.

Is there anything I can do to tell the report that if the order number isn't contained in the second table, then don't read the records in that table?

an inner join should work if you have ordernum=ordernum in where clause