View Single Post
  #21  
Old January 15th, 2010, 05:00 AM posted to microsoft.public.access.tablesdbdesign
esn
external usenet poster
 
Posts: 34
Default Lookup Field Issues

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?