That's a DUH for me!
The database was a conversion from FoxPro and I didn't notice that both
the header table and the detail table had a col called COST. I pesume
the header cost must be the total of the detail costs, So by renaming the
col in one of the tables -- all is well in Michigan now.
Thanks to Razzak for discovering this.
Bernie,
The pleasure is all mine.
Enjoy the conversion and more features from FoxPro to the
Glorious R:BASE 2000 (ver 6.5++) for Windows!
The Magical R:BASE 7.0 for Windows includes the wizard
to do it all for your next conversion project.
http://www.rbase.com/rbg7
http://www.rbaseuniversity.com
Very Best Regards,
Razzak.
