3 Replies Latest reply: Apr 30, 2013 2:31 PM by David Robinson RSS

    Object to identify Missing/Unmatched

    David Robinson

      Is there a simple way to set up and object to identify records in one table that have missing or unmatched fields in another table? I tried setting up a table box, a pivot table chart, and a straight table chart, and I was not able to get what I wanted.

      I have two tables. One loads shipment information. The other is a manually updated excel table that has conversion factors for units of measures. If a shipment is made with a new or previously unused product, I have to add a record with unit of measure conversion factors in the excel table. I would like an object to show me immediately after data refresh if I need to add a new record.