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]> 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] <[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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
