Can’t Add FileMaker Portal Row ( Security Setting )

From Dwayne Wright PMP
Certified FileMaker Developer

TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

There is a setting in the “Define Relationship” dialog box that allows you to create related records on the fly. So when you create a portal, there will always be a blank line at the bottom. To create a new related record, simply enter some information in that empty line and a related record is automatically created. Behind the scenes, FileMaker creates a new related record by adding matching information from the primary key field into the foreign key field of a related record.

You can break the ability to create records on the fly because the users security settings  in the child table will not allow it. Like many security level bugs, this can happen after the solution has been deployed and you are integrating changes requested by users. You can setup a security setting to be unable to create records in the related table or to only be able to create records if a particular calculation is TRUE. This is called record level access. Sometimes you make security changes and then realize later that you have broken a needed script or relationship.

More info about the author and FileMaker in general, contact me at

© 2007 - Dwayne Wright -

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.