Please help - Summarize Fields triggered after ODBC update!!!! Please Help

[Autoloc]

I am working with a developer who is supplying us with a rate server for shipping quotes. The problem is when we try to update a record via ODBC (System DSN). It connects fine, it searches fine, but when it goes to update it triggers the summarizing Field "FIELD_NAME" in Filemaker. The summary fields are not on the layout, and it is summarizing for EVERY record in the DB.

Please help, this is driving me nuts!

New info: Although there are no related field on the layout that is showing, FIlemaker opens every database with a related field prior to starting the summary.

Almost ready to give up...

Desperate...

Help....

[Garry Claridge]

What is the SQL statement being used for the UPDATE?

Garry