Quick Start
Table Of Contents
- Chapter 1 Welcome to FileMaker Pro
- Chapter 2 Installing FileMaker Pro in Windows
- Chapter 3 Installing FileMaker Pro in the Mac OS
- Chapter 4 New features in FileMaker Pro
- New features in FileMaker Pro 5.5
- Windows 2000 Professional
- Ease-of-use improvements
- Record-by-record access privileges
- Scripting improvements
- New logical, design, and status functions
- Extended ODBC and SQL functionality
- Import named ranges of Microsoft Excel data
- Search only the relative path for FileMaker Pro files
- Relaxed rules for mapping fields and relationships when importing scripts
- Dynamic field name matching in data import scripts
- Import more graphics file formats
- Increased productivity with FileMaker Server
- Prevent users from changing passwords
- Prevent users from creating databases
- Validation of the number of characters in a field
- Open a FileMaker Pro database via a URL (Mac OS)
- Web publishing enhancements
- Backward compatibility
- New features in FileMaker Pro 5
- Hands-on, task-oriented tutorial
- New features in FileMaker Pro 5.5
- Lesson 1 FileMaker Pro basics
- Lesson 2 Browsing information
- Lesson 3 Finding and sorting records
- Lesson 4 Creating a database and entering records
- Lesson 5 Customizing what you see
- Lesson 6 Creating lists, mailing labels, and form letters
- Lesson 7 Simplifying data entry
- Lesson 8 Automating tasks with buttons and scripts
- Lesson 9 Creating and running reports
- Lesson 10 Making databases relational
- Lesson 11 Keeping your data safe
New features in FileMaker Pro 37
Note The browser viewing the FileMaker Pro application via the
FileMaker Pro Web Companion must support cascading style sheets
for this feature to function properly.
New Web Companion options
A new security option is available to limit access to your databases.
You can now specify the IP addresses that can request data from the
FileMaker Pro Web Companion. For example, you can specify that
only IP addresses that start with 1.2.3.* can access your databases.
Additionally, the log file format has been changed to comply with
the NCSA/CERN compatible Common Log format. Also, there are
new options for tracking Web Companion activity in log files.
View as Table
FileMaker Pro has always offered two ways to view your layouts:
View as Form, which displays one record on the screen at a time, and
View as List, which displays more than one record at a time.
FileMaker Pro 5 now adds a third method of viewing your data
onscreen: View as Table. With View as Table, data is displayed in a
grid-like arrangement, similar in appearance to a spreadsheet, with
each row displaying a record and each column displaying a field.
Columns can easily be resized by dragging an edge of a column’s
heading, sorted by clicking on a column’s heading (if enabled), and
reordered by dragging a column to a new position.
Improvements to value lists
Value lists have been improved in FileMaker Pro 5, too.
There are three major improvements to value lists:
1 You can now base a list of values on a relationship. This can yield
a subset of a field’s values, rather than the field’s entire contents. The
value list will display only values from records that are consistent
with the criteria defined in the list’s underlying relationship.
1 When you are deriving values from one field, but displaying
another field’s contents, you can now choose whether to sort on the
first field (the one whose values are being stored) or the second one
(the field whose values are just being displayed).
1 It is now possible to specify a value list that is defined in another
FileMaker Pro 5 database. This allows you to reduce the repetition of
custom or field-based value lists by reusing one central list in
multiple files, and to use value lists in portals (where it’s necessary
to use a value list that must exist in the related file).
Note The external value list (using related values) must be in the
same file as the related field in the portal.
The example below shows a value list based on a relationship. The
same field is displaying a different list of values because the value in
the match field, Category, has changed.