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
30 Getting Started Guide
1 An option to change the pointer to a hand when it’s over a button
in Browse and Find modes.
Record-by-record access privileges
FileMaker Pro 5.5 extends data access control to individual records.
You can now specify calculation formulae to restrict browsing,
editing, or deleting individual records, based on the user’s password.
For example, a management-level password can be given privileges
for the records of all employees in that manager’s department. At the
same time, non-management password privileges can be limited to
browsing only an employee’s personal records.
This option is also available for databases published on the Web.
Scripting improvements
Scripting improvements include:
1 Comments in script steps now print in italics for increased
visibility.
1 The Allow Toolbars script step lets you hide toolbars and disable
the related menu items.
1 The new Set Next Serial Value script step allows you to use a
calculation expression to determine the next serial value of a field
defined as an auto-entry serial number field. This is helpful if you
want to import records into a FileMaker Pro 5.5 database with an
auto-entry serial number or if you want to delete multiple serialized
numbers from a FileMaker Pro 5.5 file.
1 In the Mac OS, the Send Mail script step now supports Microsoft
Outlook Express 5 or Entourage.
New logical, design, and status functions
New logical, design, and status functions make working with fields,
files, and layouts easier than ever. The new functions are:
1 GetField(fieldname)
1 FieldIDs(dbname, layoutname)
1 GetNextSerialValue(dbname, fieldname)
1 LayoutIDs(dbname)
1 RelationIDs(dbname)
1 ScriptIDs(dbname)
1 ValueListIDs(dbname)
1 Status (CurrentFieldContents)
1 Status (CurrentFilePath)
1 Status (CurrentHighContrast)
1 Status (CurrentHighContrastColor)
1 Status (CurrentLayoutAccess)
1 Status (CurrentODBCError)
Select to
change the
pointer to a
hand cursor
Limit
Edit records
and Delete
records
privileges for
this password