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