If I have a join form with an outer join, doesn't that mean that the join form should have all records from Form A and Form B?
I have a join form that is joined by 2 fields (no other query or anything) and when I swap the forms for Form A to be primary I get different results than when I choose Form B to be a primary. Is it because I'm joining the forms using 2 fields instead of one? Or maybe it's always been that way, and I just need a vacation. Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.com<mailto:lisa.ke...@te.com> 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]<http://www.te.com/> www.te.com<http://www.te.com/> [http://www.te.com/images/socialmedia/twitter.png]<http://twitter.com/teconnectivity> [http://www.te.com/images/socialmedia/facebook.png] <http://www.facebook.com/teconnectivity> [http://www.te.com/images/socialmedia/flickr.png] <http://www.flickr.com/photos/teconnectivity/> [http://www.te.com/images/socialmedia/linkedin.png] <http://www.linkedin.com/groups?gid=1591657> [http://www.te.com/images/socialmedia/youtube.png] <http://www.youtube.com/teconnectivity> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"