Re: v13 - Why does this query not work?

Chip: The compatibility setting is there if the structure is older than V11, I'd assume, because this feature is essentially SQL, which was introduced in V11. Check out the docs for QbF - it says auto relations aren't used "as a rule" but gives a couple of instances when the are used. Thomas Mau

Re: v13 - Why does this query not work? [resolved]

I do not know why... but doing a simple query now works. John, all of the following queries (now) work. : ($Selected_Search="has Inventory") QUERY SELECTION([Bench_Protocols];[Bnchprot_LabInv_Link]Bench_Protocol_ID=[Bench_Protocols]Bench_Protocol_ID) : ($Selected_Search="has Attached Files"

Re: v13 - Why does this query not work?

Doug, Thanks no compatibility setting - so it must already be on. I realized that the auto relations should not come into play - but when things are not working, you try ... well... whatever. :) I know about query execution, but have never really looked into it. I will. On Wed, 24 Oct 2018 1

Re: v13 - Why does this query not work?

Chip, I may be wrong but I don’t think you can query a table based on a many table relation. I would… RELATE MANY SELECTION([BnchProt_File_Link]Bench_Protocol_ID) RELATE ONE SELECTION( [BnchProt_File_Link];[Bench_Protocols] ) John John Baughman Kailua, Hawaii (808) 26

Re: v13 - Why does this query not work?

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

v13 - Why does this query not work?

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_Protoco