VISUAL QUICKPRO GUIDE FileMaker Pro 7 Advanced FOR WINDOWS AND MACINTOSH [Electronic resources]

Cynthia L. Baron, Daniel Peck

نسخه متنی -صفحه : 227/ 64
نمايش فراداده

Sorting Data in Portals

In previous versions of FileMaker, if you wanted to view the portal data sorted by one of its fields, you had to specify this option in the relationship itself. FileMaker Pro 7 has added the capability to sort portals by specifying the sort order in the Portal Setup.

To sort data in portals

1 .Go to the current table layout with the portal to be sorted and switch to Layout mode (Control+L/Command+L).

2 .Double-click in the portal. When the Portal Setup dialog box appears, click the Sort portal records check box (Figure 6.34).

Figure 6.34. Portal records can be sorted by using the Sort portal records option.

3 .

When the Sort Records dialog box appears, double-click the sort field(s) in the left column to add them to the Sort Order column on the right (Figure 6.35). You can specify ascending, descending, or custom sort order. Click OK twice to finish. The portal will now display the related records in the order you chose.

Figure 6.35. Records are sorted by the fields you move into the Sort Order.

Tip

To make a portal more readable, you can format it using alternating row colors. If you check the Alternate Background Fill option in the Portal Setup dialog box, the portal will display with different colors (or fill patterns) in each row (Figure 6.36).

Figure 6.36. Alternating row colors can make portal data more readable.