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.
 
Go Red Wings!   only hope and a prayer is left for the Pistons.
 
Bernie Lis
Megabytes, Inc.

Reply via email to