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

Setting Sort Orders

The Custom sort order is determined by a value list. Such lists—and their order—are typically created when fields are first being defined (see Defining Fields on page 99). However you can change the order of a value list—and thereby the Custom sort order—any time.

To set (or reset) a custom sort order:

1.
Choose Records > Sort or use your keyboard: (Windows) or (Mac).

2.
The Sort Records dialog box will appear (Figure 5.47). If the field name for which you want to create a custom sort order is already listed in the right-side list, click on it there and go to step 3.

Figure 5.47. Click the radio button labeled Custom order based on value list, wait for the pop-up menu to appear, and choose Define Value Lists.


If the field name for which you want to create a custom sort order has not yet been selected and moved to the right side, click on its name in the left-side list. Now click the Move button, which will place the field's name in the right-side list.

3.
By default, the field's sort type is Ascending. To change the type to a Custom order, click the radio button labeled Custom order based on value list, wait for the pop-up menu to appear, and choose Define Value Lists (Figure 5.47).

4.
When the Define Value Lists dialog box appears, click New (Figure 5.48).

Figure 5.48. When the Define Value Lists dialog box appears, click New.


5.
When the Edit Value List dialog box appears, type an easy-to-recognize name into the Value List Name box, then type each of your custom values into the right-side box in the exact order you want them sorted (Figure 5.49). When you're done, click OK.

Figure 5.49. Use an easy-to-recognize word for your Value List Name, then type your custom values in the right-side box in the exact order you want them sorted. When you're done, click OK.


6.
When the Define Value Lists dialog box reappears, click Done.

7.
When the Sort Records dialog box reappears, click Sort to apply your Custom order. The records will sort out in the order of the names in the Streets value list (Figure 5.50).

Figure 5.50. Once you run the Custom sort, the record sequence mirrors the order of the value list.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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