If the relationship is tied to a calculation field, FileMaker Pro cannot automatically populate it with a value from a related record (see Figure 16.4).įigure 16.4. You also need to be able to modify the field in question. In the case of greater-than-or-equal and less-than-or-equal operators, FileMaker pushes data into newly created records based on the equal-to value. Similarly, a ) in which FileMaker can determine exactly the foreign value to populate in the newly created record. A portal based on such a relationship would therefore display all the records of the related table. A Cartesian cross-product operator (x), for instance, relates all the records in one table to all the records in another table, regardless of key values. However, a portal's basic function of displaying one record per row from a related table remains essentially the same. ![]() The match criteria you've established determine the perspective, and, depending on how you've set things up, it is possible to change that perspective to useful ends.įileMaker Pro 7 introduced new relationship operators, beyond the single equijoin (=), and portals have become even more flexible than in the past. In each row of your portal, you will see fields from records as they relate to the current record to which the portal is tied.Īnother way to think of portals is that they offer a view into another table from a specific perspective. As previously mentioned, a portal is a view into a related table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |