>>
>Tamar,
>
>Pretty much the same with me. As I mentioned to JimB, I've a bunch of intentionally de-normalized tables (because of the report requirements) which require multiple groupings (up to 20+ in one case). From strictly a maintenance standpoint, breaking the rules here is almost a necessity.
>
I know I joked with you about normalizing (in regards to this topic) a couple of weeks ago...
Even if the data is normalized, you'll still end up de-normalizing to create cursors for the VFP report writer.
So, yep, it would be a pain without SET ENGINEBEHAVIOR...
Steve Gibson