I have a report whose Source = 2 tables in a query where they share a common field: "Order Number". There is a 3rd table that adds the package size information. The Report is set up shows the product that is being ordered at the bottom and a third table shows the shipping dimensions of the package and contains the Pallet number. The pallet number is staged to the PO number and tied to the financial side. So, where I have 2 unique entries in 2 different tables, I end up with duplicate listings of the product and lot. I even checked the "Unique Value" in the Query/Properties window and that didn't stop it. Any suggestions?