Chuck, My suggestion would be: The primary query loads the index, and does the query from the index, only the first [Invoice item] record found will be loaded, and there happens not to be a relational loop (see below). The QSxF will need to load each record.
Since you have a lot of auto relations, you might have a 'long way around' (tm) relational path. maybe something like: [invoice_line] -> [Invoice] -> [customer] -> [order] which is changing the order selection/record and unloading it Personally - i very rarely use auto relations for just such issues :) Chip On Thu, 7 Jun 2018 12:53:47 -0400, Chuck Miller via 4D_Tech wrote: > env v 15.x > > I have the following set up > > order table > order line table related auto to order > invoice line table related auto to order line > packing list table related auto to invoice one table > > I have the following queries > > QUERY([Order];[Order]Order_ID=$OrderIDS_aL{$Loop_L}) > // on record found > $OH_CustomerPartNumber_atxt{$Loop_L}:=[Order]Cust_Part_No > QUERY([Invoice_Line];[Invoice_Line]Packing_List_ID=$OH_PackingListIDS_aL{$Loop_L}) > //order record still loaded > QUERY SELECTION BY FORMULA([Invoice_Line];Find in > array($as_charges;[Invoice_Line]Item)=-1) > order record sometimes unloaded. > > Any ideas as to what is going in. Why would the order be unloaded > after query by formula and not by the initial query > > > Thanks and regards > > Chuck > ------------------------------------------------------------------------------------------------ > Chuck Miller Voice: (617) 739-0306 > Informed Solutions, Inc. Fax: (617) 232-1064 > mailto:cjmiller<AT SIGN>informed-solutions.com > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D and Sybase connectivity > http://www.informed-solutions.com > ------------------------------------------------------------------------------------------------ > This message and any attached documents contain information which may > be confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, > disclosure, printing, copying, storage, modification or the taking of > any action in reliance upon this transmission is strictly > prohibited. Delivery of this message to any person other than the > intended recipient shall not compromise or waive such > confidentiality, privilege or exemption from disclosure as to this > communication. > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************