Got it, so the Primary form (on my Join Form) will be the one with all the records on the join form.
Weird, I never noticed that..... Thanks! Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Thursday, October 27, 2011 2:37 PM To: [email protected] Subject: Re: Join Forms and Outer Joins ** Lisa, A Left Outer join gives you all records from Left, and only those from Right that match the join criteria. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: Thursday, October 27, 2011 12:04 PM To: [email protected] Subject: Join Forms and Outer Joins ** 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 [email protected]<mailto:[email protected]> 100 Amp Drive Harrisburg, PA 17112 [cid:308331119@27102011-2242]<http://www.te.com/> www.te.com<http://www.te.com/> [cid:308331119@27102011-2242]<http://twitter.com/teconnectivity>[cid:308331119@27102011-2242]<http://www.facebook.com/teconnectivity>[cid:308331119@27102011-2242]<http://www.flickr.com/photos/teconnectivity/>[cid:308331119@27102011-2242]<http://www.linkedin.com/groups?gid=1591657>[cid:308331119@27102011-2242]<http://www.youtube.com/teconnectivity> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<inline: ~WRD000.jpg>>

