AnsweredAssumed Answered

Deleting Record Reverts edits to Related Record

Question asked by philmodjunk on Aug 11, 2011
Latest reply on Oct 31, 2011 by philmodjunk

Summary

Deleting Record Reverts edits to Related Record

Product

FileMaker Pro

Version

11.03

Operating system version

Windows 7

Description of the issue

If a script modifies a field in a related record, then deletes the current record, the related record reverts to previous stored values.

Steps to reproduce the problem

Section of script looks like this:
Set Field [RelatedTable::Count ; RelatedTable::Count - 1]
Delete Records [no dialog ]

Configuration information

I used the debugger to step through the script. I could see the value change correctly, but when I then checked the values in the related record, they were unchanged.

Workaround

use commit record after editing the values in the related record.
Set Field [RelatedTable::Count ; RelatedTable::Count - 1]
Commit Record []
Delete Records [no dialog ]

Outcomes