AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Filemaker pro 18 portal scrolling5/10/2023 ![]() It is unlikely that you'd want to retain just the phone-number records after deleting the contact record to which related phone records belong. A good example might be a contact person's record and related phone-number records. This cascading effect ensures that your database doesn't orphan records by allowing a user to delete records without their respective related records. Choosing this option ensures that when a user deletes a record in one related table, all its related records are deleted as well. The next option is Delete Related Records in This Table When a Record Is Deleted in the Other Table. Note that the match field, shown here in the third column, is populated automatically.įor more depth on relationships and relationship properties, see Chapter 6, "Working with Multiple Tables," p. 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
Read More
Leave a Reply. |