I have two tables linked.
One of the tables [Order_Customer_Shippments] contains the customer order information with a field that specifies the customer order number, date, and shipment method "UPS RED, UPS BLUE, etc.
The other table[UPS_Info4FS] contains the UPS Shipment information of orders that have shipped out of the factory. This table contains some of the same fileds including the customer order number.
If a record with a customer order number is found in [Order_Customer_Shippments] but not found in [UPS_Info4FS], I would like to generate a report showing the [Order_Customer_Shippments] records that don't match to the [UPS_Info4FS].
While I understand the filters for the shipment methods, I am struggling on how to join or compare the records from the two tables to display the records that don't match based on the customer order field.
One of the tables [Order_Customer_Shippments] contains the customer order information with a field that specifies the customer order number, date, and shipment method "UPS RED, UPS BLUE, etc.
The other table[UPS_Info4FS] contains the UPS Shipment information of orders that have shipped out of the factory. This table contains some of the same fileds including the customer order number.
If a record with a customer order number is found in [Order_Customer_Shippments] but not found in [UPS_Info4FS], I would like to generate a report showing the [Order_Customer_Shippments] records that don't match to the [UPS_Info4FS].
While I understand the filters for the shipment methods, I am struggling on how to join or compare the records from the two tables to display the records that don't match based on the customer order field.