Chip: Check your settings in Database Settings/Compatability - check the query by formula uses SQL joins and you'll want to Execute QbF on Server, as well. :-)
I don't think that Auto relations comes into play. Try creating the join yourself, a la: QUERY BY FORMULA([Contacts];([Proposal_Contact_Link]ProposalID=$proposalID_T) & ([Contacts]ID=[Proposal_Contact_Link]ContactID)) Also, and I meant to give you a heads up on this the other day, it can be very helpful to see how 4D is running the query. I call this code before a query DESCRIBE QUERY EXECUTION(True) and call QRY_QueryPlanToClipboard after the query. Code in QRY_QueryPlanToClipboard: C_TEXT($plan_T;$path_T) $plan_T:="Query Plan"+Char(13)+Get last query plan(Description in text format) $path_T:="Query Path"+Char(13)+Get last query path(Description in text format) SET TEXT TO PASTEBOARD($plan_T+Char(13)+Char(13)+$path_T) HTH. -- Douglas von Roeder 949-336-2902 On Wed, Oct 24, 2018 at 10:33 AM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Structure: > [Bench_Protocols] <- [BnchProt_File_Link] -> [Attached_Files] > > QUERY SELECTION BY > > FORMULA([Bench_Protocols];([BnchProt_File_Link]Bench_Protocol_ID=[Bench_Protocols]Bench_Protocol_ID)) > > I have tried: > QUERY SELECTION > > ([Bench_Protocols];[BnchProt_File_Link]Bench_Protocol_ID=[Bench_Protocols]Bench_Protocol_ID) > > > The relations are manual and I have tried adding > SET AUTOMATIC RELATIONS(True;True) > > there are records in the linking table ([BnchProt_File_Link]) with IDs > that match [Bench_Protocols] records, but nothing returns any records. > > Ideas? > Thanks > Chip > > --------------- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
