U.M. (Windows)
Table Of Contents
- Preface: Getting help
- Chapter 1: FileMakerPro basics
- Chapter 2: Creating a database file
- Chapter 3: Laying out and arranging information
- Understanding layouts
- Working with predefined layout types
- Arranging records in columns
- Managing layouts
- Working with layout parts
- Changing layout parts
- Working with all object types
- Working with graphic objects
- Working with fields in a layout
- Adding fields to a layout
- Adding merge fields
- Deleting a field from a layout
- Defining display formats for fields
- Determining data entry in fields
- Setting the tab order for data entry
- Adding scroll bars to fields
- Formatting repeating fields
- Adding borders, fill, and baselines to fields
- Defining value lists
- Formatting fields with value lists
- Working with text
- Chapter 4: Working with information in records
- Working in Browse mode
- Adding data to a file
- Selecting a field for data entry
- Adding and duplicating records
- Entering and changing data in fields
- Working with container fields
- Entering data from a value list
- Viewing and inserting data from another source
- Copying and moving values and records
- Using drag and drop to move information
- Replacing field values
- Working with records
- Finding information
- Deleting records
- Sorting records
- Chapter 5: Using ScriptMaker and buttons
- Chapter 6: Previewing and printing information
- Chapter 7: Networking and access privileges
- Chapter 8: Importing and exporting data
- Chapter 9: Customizing FileMakerPro
- Chapter 10: Using data from related files
- Chapter 11: Publishing files on the Web
- About the World Wide Web
- About FileMaker Pro Web Companion
- Publishing your database on the Web—an overview
- Getting ready to publish your files on the Web
- Setting up FileMaker Pro Web Companion
- Configuring FileMaker Pro Web Companion
- Setting up Instant Web Publishing
- Database security
- Helping Web users find your database
- Custom Web Publishing
- Appendix A: Recovering damaged files
- Appendix B: Working with international files
- Appendix C: Summary of functions
- Appendix D: Linking and embedding objects
- Index
- Quick Reference
3-74 FileMaker Pro User’s Guide
Defining value lists
To save time and ensure accuracy during data entry, define frequently
used text, number, date, or time values to display in a pop-up menu or
pop-up list (drop-down list), or as checkboxes or radio buttons (option
buttons). When you enter data, choose from the list of defined values.
Value lists aren’t attached to any field definition but can be shared by
several fields. The values in a value list can be user-defined or based on
the values in a field in the same file or in a different file.
After you define a value list, you can use it to validate any field. (See
“Choosing data entry options” on page 2-6.)
To define a value list:
1. Select a field on the layout for which you want to use a value list, and
then choose Field Format from the Format menu.
2. In the Field Format dialog box, for Style, select Pop-up list using value
list
<value>
, and then choose Define Value Lists from the drop-down list.
3. In the Define Value Lists dialog box, for Name, type a name for the
list, and then click Create.
4. Define the value list.
To Do this
Create a list of values Select Use custom values, and then type each value on
a separate line, in the order you want them to appear.
Press Return to separate each value.
Choose from existing values in a
different field
Select Use values from a field, and then click Specify
Field. In the Specify Field for Value List dialog box,
to choose from a field in a different file, click Specify
File, and then choose a filename. For Use values from
this field, click the name of a field, and then click OK.
Choose from this list of
values during data entry