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

A jargon jump-start

Each relationship in FileMaker includes only one master (destination) file and one related (source) file. But you can create multiple relationships, which means the same file can be the destination (master file) for some data and the source (related file) of other data. Whether you're dealing with a file, a record, or a field, just keep straight where the data's coming from (the source) vs. where it's eventually going to (the destination). For a bit of lingo help, see Table 14.1, Too Many Terms for Two Simple Ideas.

The examples in this chapter are based on three database files: “3D,” which lists products from 3D software companies; “3D vendor addresses,” which lists all the contact information for each company; and “3D Books,” which lists information about books that explain how to use the software program (Figure 14.1). To put all the information in a single database file would be unwieldy. By dividing it into three files, each database remains focused and simple to use, which is what relational databases are all about. As you read the rest of the chapter, refer back to Figure 14.1 to see how these three relational files put relationships, match fields, lookups, and portals to use.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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