Yup, that's how I set it up. Form with all the records is set as the primary and the one with partial records is set as the secondary. The problem isn't that it's showing too few records. It's showing too many heh. It's like it's disregarding the join qualification.
------------- Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: Wednesday, November 07, 2007 12:32 AM To: [email protected] Subject: Re: Outer Join ** If this is the case; you should swap forms A and B. In an outer join, you should always put the form that will contain all records on the 'left' side (form A). -- Met vriendelijke groet / Kind regards Michiel Beijen ______________________________________________________ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl On 11/6/07, Wheeler, Dylan < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: ** Does a join form disregard the join criteria if it's an outer join and the secondary form doesn't have a matching primary form record? I know I can't use = in the criteria but on a join I have between two forms I use the qualification of ( $Status$ != "Scrap" ) AND ( 'Request ID' = $Request ID$) It's showing all the records though, scrap or not. I need it to be an outer join because the secondary form doesn't have an entry for each primary form record. Maybe I'm going about it wrong? Or am I running into another join inadequacy like I had with distinct records? heh ------------- Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
