Hi George,try using one of the qualifiers found here: http://www.bernard-web.com/pierre/webobjects/code.html These were suggested to me by Chuck a few days ago. I'm certain they'll solve your problem. You have to build them as Framework and put that in your project. If you just copy the source file
When building a compound qualifier for a many-to-many relationship, against flattened relationships, EO doesn't seem to generate the appropriate SQL.Structure: Record <<-->> Group (where as these are flattened relationships with a intermediary RecordGroup join table)Qualifier: Records belonging to
