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 **********************************************************************
