Hi MMartin1

Thanks for your response, while my tables do have check and RI constraints I also use surrogate keys and therefore most of my data import type packages perform some kind of look-up, using the alternate keys, to get the surrogate primary key to be used as foreign keys... hopefully that made sense.

So I often have a list of dodgy values, e.g. they were not found, before attempting an insert/update It is theses values that I want to capture and eventually store in a table for reporting purposes.

Thanks

Steve