Skip to Main Content
FileMaker Pro 14: The Missing Manual
book

FileMaker Pro 14: The Missing Manual

by Stuart Gripman, Susan Prosser
May 2015
Beginner to intermediate content levelBeginner to intermediate
970 pages
32h 12m
English
O'Reilly Media, Inc.
Content preview from FileMaker Pro 14: The Missing Manual

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

FileMaker Pro 11: The Missing Manual

FileMaker Pro 11: The Missing Manual

Stuart Gripman, Susan Prosser
FileMaker Pro 12: The Missing Manual

FileMaker Pro 12: The Missing Manual

Susan Prosser, Stuart Gripman
FileMaker Pro 10: The Missing Manual

FileMaker Pro 10: The Missing Manual

Susan Prosser, Geoff Coffey
FileMaker Pro 9: The Missing Manual

FileMaker Pro 9: The Missing Manual

Geoff Coffey, Susan Prosser

Publisher Resources

ISBN: 9781491917473Supplemental ContentErrata Page