Modifying related records through portals

Expert

Understand the commit behavior, locking, and validation rules that apply when users edit related records through portal rows.

What you'll learn

  • Which record is locked and committed when editing a portal row
  • How validation rules on the related table apply to portal edits
  • How OnObjectModify and OnObjectCommit triggers fire in portal context

When a user edits a field inside a portal row, they are editing the related record, not the parent. Commit behavior, record locking, validation, and script triggers all apply to the related record independently from the parent. Understanding this separation is essential for building portals that behave predictably.

1/3
1

What "current record" means in a portal

When the user clicks into a portal row, the related record becomes the active record for field editing purposes. The parent record remains displayed but is not in edit mode for that portal's related table.

FileMaker Script
// When editing LineItems in a portal on Invoices:
// Get(RecordID)         → ID of the parent Invoice record
// LineItems::id         → ID of the related LineItem row being edited
// Commit Records/Requests → commits the related LineItem record
Organizing and documenting the Relationships GraphSummary fields vs. aggregate calculations across relationships

Sign in to track your progress and pick up where you left off.

Sign in to FM Dojo