Table of contents
What is a related table in FileMaker?
In a database, a related table is a table that is linked to the current table via a specific criterion. For example, if you are currently in a FileMaker database in which customer data is displayed, the tables Contact person, Addresses or Documents Reference tables for the main table Customer data.
Related tables can be linked to each other using a wide variety of criteria. The classic case is the 1:n link, in which a data record from the main table is linked to several data records from the related tables.
Each related table is linked to the foreign key _fk_Kunden_ID of the related table via the primary key (_pk) of the main table. If the customer ID matches, the data record in the related table belongs to the customer called up and there can be any number of data records in the related table with matching customer IDs.
In FileMaker databases, tables can be linked in a variety of ways. For example, you can set whether the reference criteria should match or be smaller (or equal) or larger (or equal) or not match or match all.
If global fields are used as keys of the main table, script-controlled hierarchical structures can be controlled in sections. If the user selects a row in the section, a script updates the global key for the second section.
More questions about FileMaker? It's quicker in person.
As part of our Coaching and training services we will be happy to inform you personally about the FileMaker functions you need for the development of your FileMaker solution. Of course, we will be happy to respond to your individual wishes. Billing is individual and fair in 15-minute increments. Pay conveniently by bank transfer or PayPal.
