Using Multi-key Relationships

Within FileMaker development, there are a variety of must-know features and methods for doing certain things. You’ll be hard pressed to find these critical bits of info within the provided help.

However, these are nuances which come with the environment and really only make sense once you start to integrate them into your user interfaces. One of these “hidden” features is known as Multi-key relationships.

Using multi-key relationships, you can present data within the user interface which is derived from a variety of tables. There’s really no limit on how much data you can show from however many tables you desire. The limitation is truly only your imagination about how the data should be presented.

While the implementation is super easy, the understanding behind how things work is what will move your FileMaker solutions to the next level.

AttachmentSize
UsingMulti-keyRelationships.zip1.65 MB

Comments

Hi
thanks for the video and the example file.
I was wondering if, using this technique, is it possible to join the records from the two tables in a single portal?
I already have 4 portals related to 4 diferent tables using this technique and they not allways show information. I would prefer to have a single portal showing all the related records.
Thanks in advance