• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part: III Creating FileMaker Solutions > Working with Relationships

Hour 14. Working with Relationships

What You'll Learn in This Hour:

  • Introducing the Relational Model— Used by most databases today, the relational model lets you combine data from a number of tables for efficient use.

  • Normalizing a Database— These techniques optimize performance and logical storage. They apply to all relational databases.

  • Add Tables to a Database— To create relationships in FileMaker, you first need to add tables to your database.

  • Create Relationships— This section shows you how to create the relationships between tables.

  • Relationships to Aliased Tables— Here you'll find out how to create relationships to tables in other database files as well as multiple relationships to tables within your own database file.

  • Using File References— If you are accessing other database files, you need to create file references.

  • Using Self-Joins— Self-joins can provide simple error-checking and data manipulation within a single table.

  • Working with Contexts— Contexts locate a layout on the relational graph. You'll see what this means in this section.

  • Using Lookup and LookupNext Functions— These functions let you retrieve related data and manipulate it.

The examples so far in this book have consisted of simple databases, most of which contain a single table. That's fine for many purposes, but to really unlock the power of FileMaker (or, indeed, of any relational database), you need to move on to multiple tables and relationships. This hour shows you the basics of creating relationships.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint