For this example, we chose to show FirstName, LastName, Position, and PositionStartDate from the TownOfficer table. You can also apply coloring or striping to the portal if you choose.įileMaker also displays a dialog at the end of the portal creation process, asking which fields from the related table you want to show in the portal. For now, you can opt to display just 12 portal rows, and put a vertical scrollbar on the portal so that you can scroll down if a town has more than 12 officers. The Portal Setup dialog contains a number of other choices as well. By choosing TownOfficer from this menu, you're instructing FileMaker to show you all town officer records that are related to the currently visible town record (in other words, all that share the same town ID). (The question of whether a table is "related" or "unrelated" is determined by the Relationships Graph.) In the current example, for a portal on a layout in which the table context is the Town table, there should be only one available choice in the menu: the TownOfficer table, which is the only other table related to Town in the Relationships Graph. The list is divided into sections: one for related tables and one for unrelated tables. In the Portal Setup dialog, the Show Related Records From list enables you to choose which table to draw data from. More details on each of these steps follow.įirst, you need to specify where the portal gets its data. Choose data fields for display in the portal.Choose a table occurrence from which to display data.In general, when you set up a portal for the first time, you'll need to do the following: The dialog is shown in Figure 6.10.įigure 6.10. You'll get a dialog box asking for details about the portal's contents, behavior, and display. You should be able to tell the table context by the fields on the layout, but you'll recall that the Layout Setup dialog, accessible from the Layouts menu while in Layout mode, gives the definitive answer.Ĭlick once on the tool, and then, on the layout, drag out a box wide enough to show an entire town officer's name and release the mouse. This is a layout in Layout mode, showing the FileMaker portal tool. After you're on this layout, drop into Layout mode and you'll see the portal tool among the available tools in the status bar (see Figure 6.9).įigure 6.9. To see a portal in action, navigate to a layout that has the parent table (Town, in this case) as its table context. In the case of the Towns database, a portal lets you look at records in the TownOfficer table while you're sitting on the "parent" Town record.įor addition discussion of the "parent/child" naming convention, see "One-to-Many Relationships," p. A portal is a special FileMaker layout element that lets you work with data across two (or sometimes more) tables at once. Additionally, there's no way to see a list of town officials when looking at the master town record in the Town table.įileMaker solves both these problems with a tool called a portal. 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. One way would be to navigate to the TownOfficer layout and create a record for each official, assigning a TownID of 1 to each. 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. The town records database system has two tables in it now. Using a Portal to View Related Child Data
#How to show all fields and tables in filemaker pro 14 how to
This section shows you how to begin to use your relationships to work with and create data in multiple tables at once. 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.
0 kommentar(er)
