Allow creation of records via a relationship
BeginnerEnable "Allow creation of records via this relationship" so users can create new child records directly from a portal row, and understand what FileMaker sets automatically.
What you'll learn
- Where to enable "Allow creation" in the Relationships Graph
- What FileMaker automatically sets in the new related record
- How to use the Go to Portal Row script step to position focus for entry
When "Allow creation of records" is enabled on a relationship, typing in the empty row at the bottom of a portal automatically creates a new related record with the foreign key pre-filled.
1/3
1
Enable Allow creation in Edit Relationship
Open the Relationships Graph, double-click the relationship line, and check "Allow creation of records via this relationship" on the child table's panel.
FileMaker Script
Edit Relationship dialog:
Left table: Customers Right table: Orders
[ ] Allow creation of records [✓] Allow creation of records
via this relationship via this relationship
# Only check the side that should create new records.
# For a Customers→Orders portal: check the Orders side.Sign in to track your progress and pick up where you left off.
Sign in to FM Dojo