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

Chapter 6. Working with Multiple Tables > Working with Related Data

Working with Related Data

So far in this chapter you've learned how to create additional tables in a FileMaker system and how to build relationships between those tables based on well-constructed match fields. This section shows you how to begin to use your relationships to work with and create data in multiple tables at once.

Using a Portal to View Related Child Data

The town records database system has two tables in it now. But how do we use them? Say there's a record for a town called Gorre, with a TownID of 1, and you want to enter information about the mayor and town councilors of Gorre. One way would be to navigate to the TownOfficer layout and create a record for each official, assigning a TownID of 1 to each. That seems like a tedious way to create data, and it's potentially error-prone because a user must know and correctly enter the TownID of every town. Additionally, there's no way to see a list of town officials when looking at the master town record in the Town table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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