Chapter 6. Creating and Managing a Relational Database

In Part 2, you learned the fundamentals of creating a custom database. You saw that you could create tables and fields whenever you need them. You learned how to polish layouts and add features and designs that make your data easy to maintain and analyze. You even learned how to harness the powerful combination of buttons and scripts.

And you did all those things in an organic fashion; as the need arose, you created elements that gave your database more power. FileMaker’s flexibility let you make these improvements without much advance preparation. But as the databases you create get more sophisticated and the tasks you need them to perform get more complex, you’ll find that the right kinds of planning and preparation make development go more smoothly. It’s time to start thinking like a database developer, so your database can grow as your needs grow.

In this chapter, you’ll learn how to create a road map for the tables and fields that comprise your database. (Database nerds called this map their database’s schema.) Before you define the first table in your database, it pays to sit down and think about the kinds of data you’ll be storing. Think about the basic tasks the database handles and how those tasks get carried out. This chapter shows you how to plan your database schema and then start putting that plan into action.

Tip

Go back and read the box on These Terms Are Relational if you want to review basic database and relationship ...

Get FileMaker Pro 14: The Missing Manual now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.