Auto-entry calculations in related tables

[jfmcel]

I've been working on an implementation of the separation model and have found a significant problem. Things were progressing fine until I implemented an audit trail -- using Nightwing

AuditTrailTest.zip

[RalphL]

Sorry that this is so late but I was out of town for a while and had to study the method so I could understand what was going on. Normally your interface file has no table or a one record table.

The problem starts with FMP7's Get ( ActiveFieldName). It only works in the file where the field is shown. The solution is to make an unstored calculation field Field_Name = Get ( ActiveFieldName ). In your Related file make a relationship to Main. Use the Cartesian Cross Product relationship ID [X] ID. In the calcaulation for AuditTrail_related replace Get ( ActiveFieldName) with Main::Field_Name.