Hi Doug,
Defined properly... Hmmm.... You want to put me on the spot ;-)
What I'm wondering about it this. Many indexes were defined depending on some processing that has to be done in the application. Would'nt it be worth it to create a data engine class? Doing that could improve the overall performance of SFR by eliminating some relations that are not necessary for the reports. If I use another data engine class do I need to re-create RepMeta?
To answer your question when I look in RepMeta there are relations that were created. I assume that those are correct. So I also assume that the relation collection is also set up properly.
>Hi Denis.
>
>>I pick two fields from a given table. After selecting those fields I chose another table. And then I click to pick a field. When I click to add that field to the ones that were already selected I get the error message.
>
>Do you have the relation collection set up properly? I seem to recall that if the relations between the tables aren't defined properly, then the recursive routine in SFReports (actually, SFQuery) that determines how to join the tables in the report thrashes and creates too many variables.
>
>Doug
*******************************************************
Save a tree, eat a beaver.
Denis Chassé