On Thu, 14 Jan 2010 21:00:53 -0800 (PST), esn wrote:

John - there's one more thing I forgot to ask - given your query setup
what happens to records in which the plant code (the lookup value) is
correct, but data in another field violates a validation rule? Would
I have to set criteria in the queries to test all of the fields in the
source data?

I guess I don't understand. What do you WANT to happen when you have invalid
data? Add it to the table anyway?

--

John W. Vinson [MVP]