>I did your test. I got the same result as you. But I wonder about the presence of the "1 Val 1" in the final result? It's the same in both side, nothing different between test and test1 for this record. The union is not suppose to retain only the different records?
No, UNION just filtering duplicate records and leave one of them in result set.
Becuase I didn't follow whole thread I would ask you a question that you maybe alread answer,: Did you have a key field(s) in Master table, something that make record unique (but not RecNo() :o)))) ?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.