FileMaker Contextual Relationships And Layouts

From Dwayne Wright PMP, PMI-PBA, PMI-ACP, CSM
Certified FileMaker Developer

TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

So as you know, FileMaker has the ability to have multiple tables within a file. This increased capability does have one slightly bitter after taste. Since you can have multiple tables in a file, FileMaker constantly has to know what table you are addressing at the time you do many common things, such as ….

- what layout does the table belong to
- what table(s) do a calculation elements refer to
- what table(s) are touched during the various stages of script execution
- what table(s) are needed for dynamic value lists
- and the list goes on and on

For many of these questions that are not layout specific, still come back to the current layout and how it is setup.

Here you can see in the middle of the layout setup dialog box where you choose what table occurrence you are attaching the layout to.

FileMaker will use the linked table occurrence for all the fields that are on it and scripts that are running on it at that time. The common term for this is table context.
More info about the author and FileMaker in general, contact me at

© 2008 - 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