Re: Join Forms and Outer Joins

2011-10-27 Thread Kemes, Lisa 
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:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Thursday, October 27, 2011 2:37 PM
To: arslist@ARSLIST.ORG
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:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Thursday, October 27, 2011 12:04 PM
To: arslist@ARSLIST.ORG
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
lisa.ke...@te.com<mailto:lisa.ke...@te.com>
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"
<>

Re: Join Forms and Outer Joins

2011-10-27 Thread LJ LongWing 
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:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Thursday, October 27, 2011 12:04 PM
To: arslist@ARSLIST.ORG
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
lisa.ke...@te.com
100 Amp Drive

Harrisburg, PA 17112

 <http://www.te.com/>  

www.te.com <http://www.te.com/>  

 <http://twitter.com/teconnectivity>
<http://www.facebook.com/teconnectivity>
<http://www.flickr.com/photos/teconnectivity/>
<http://www.linkedin.com/groups?gid=1591657>
<http://www.youtube.com/teconnectivity> 

 

_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"
<<~WRD000.jpg>>

Join Forms and Outer Joins

2011-10-27 Thread Kemes, Lisa 
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
100 Amp Drive
Harrisburg, PA 17112

[http://www.te.com/images/socialmedia/smallTElogo.gif]

www.te.com

[http://www.te.com/images/socialmedia/twitter.png]
 [http://www.te.com/images/socialmedia/facebook.png] 
  
[http://www.te.com/images/socialmedia/flickr.png] 
  
[http://www.te.com/images/socialmedia/linkedin.png] 
  
[http://www.te.com/images/socialmedia/youtube.png] 



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"