I have a simple sum statement on table a. This sum statement is within a scan/endscan of table b.

When I run the sum statement on table a it sends table b immediately to eof().

It seems to be acting as if I have a relation set from table a to table b, but I don't.

Any ideas?

Thanks,
Paul