Database Reference
In-Depth Information
Editing a Value List
If your business rules change and you need to change the values that display in the value list,
it's easy to edit. Select the field your value list is attached to (Lease Duration, in this case),
open up the Inspector to the Data tab and then click the pencil icon next to the value list's
name. Click Edit and then make the appropriate changes. Click OK until you're back on your
layout. Finally, switch to Browse mode to see the new values.
NOTE
Changing the value list has no effect on any data that's already in that field. But now you have the
option to select the new value going forward.
Adding a Drop-Down Calendar to a Field
FileMaker is picky about how you store dates in date fields. To make data entry easy, you
can add a handy visual calendar to your date fields. Here's how.
1.
In Layout mode, click the Date Signed field to select it and then click the Inspect-
or's Data tab, if it isn't visible
.
If the whole Inspector has disappeared, choose View→Inspector.
2.
In the Field section of the Inspector, choose “Drop-down calendar” from the
Control Style pop-up menu
.
It's the last item on the list.
3.
Choose the “Include icon to show and hide calendar” option
.
The calendar will drop down even if you don't choose this option, but this way your
users can tell it's there.
Switch to Browse mode. You'll see the calendar icon at the right edge of the Date Signed
field (
Figure 3-17
). Click the icon to view the calendar pop-up menu. If there's data in your
field, the calendar will be set to show that date. The calendar's left and right arrows move the
display to the previous and next month. Its up and down arrows go to the next and previous
year on the Mac or click the Month/Year title to change years in Windows. Your keyboard ar-
row keys move through the calendar's dates. To enter the current date, just click the Today
line at the bottom of the calendar.
