Creating New FileMaker Child Records Via A Displayed Portal

From Dwayne Wright PMP
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts


Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit or other formatting of the posting may fail. For the best experience, please visit the journal directly by clicking (here).

It is quite common to create new child records from a portal within a parent file record. First you need to make sure the relationship options are set to allow the creation of related records. This option can be found in the lower third of the define relationship dialog box. It is available on both sides of a relationship due to FileMaker’s bi-directional nature.


Here you can see that one side of the relationship can create related records on the fly and the other cannot.

When you go back to Browse mode, the portals that use this relationship will have an empty bottom row. A user can click into one of the fields in this row and add data. As soon as the users adds data to that portal row, a new child record is created and the child key field is automatically populated with the parent key information. This insures the portal relationship is valid.

This concept of a blank row at the bottom is for new rows of data ... is ... well ... a bit confusing for some. The empty portal row to them looks like just that ... an empty portal row. They may not jump to the conclusion that it is an opportunity to create a related record.

So it is not uncommon for some developers to add their own personal touches to the process of adding new rows of portal data. These usually involve the use of scripts, buttons and sometimes global fields. We will cover some of these different techniques later on in this guide.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

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.