User manual

I-12 FileMaker Pro User’s Guide
importing 12-2
sorting 8-11
summarizing data 8-12
Relational databases
See also Portals; Related
fields; Related files; Related
records; Relationships
copying related records 2-5
defining 8-9
defining portals 6-19
deleting related records 2-5
described 8-2
duplicate filenames for 8-10
finding and omitting related
records 3-4
many-to-many relationships
between data 8-15
master file
described 8-2
planning 8-8
match fields
described 8-2
planning 8-5
one-to-many relationships
between data 8-4
one-to-one relationships
between data 8-4
planning 8-7
portals 8-2
sorting 3-9
terminology 8-2, 8-6
Relationships
See also Relational databases
changing 8-12
changing for portals 8-12
changing related file 8-10
defining 8-10
described 8-2
joins, for many-to-many
relationships 8-15
planning 8-9
self-joins 8-5
sorting in dialog box 8-11
to and from same file 8-5
Relookups, described 8-13
Remarks, in scripts 10-9
Remote Data Access Companion
15-2
Remote files, sharing
via ODBC 15-3
Web 14-5, 14-8
Removing. See Deleting
Renaming layouts 6-8
Rendering layouts, on Web 14-12
Reordering
field definitions 5-12
layout parts 6-29
layouts 6-8
Script menu items 10-11
script steps 10-4, 10-10
sort fields 3-8
Repeating fields
defining 5-11
described 5-11
exporting 12-8
formatting 7-7
importing 12-5
separating 12-8
sorting on 3-9
splitting 12-8
tab order 7-9
using in calculations 11-9
Repeating find requests 3-5, 3-7
Repeating functions 11-9
Repeating panels. See Portals
Repetitions. See Repeating fields
Replacing
data during import 12-2, 12-3
data in multiple records 2-10
text 2-14
Reports
See also Layouts;
Subsummaries
adding date, time, page
numbers 7-11
Columnar list/report 6-5
creating 6-2
previewing 4-3
printing 4-4
records in columns 6-8
with grouped data
creating 6-3, 6-5
printing 4-3, 4-4, 6-28
Requests. See Find requests
Requirements
exporting 12-7
importing 12-7
Web Companion 14-3, 14-4
Reserializing records 2-10
Resizing
layout parts 6-30
objects 6-14, 7-19
Restricting access. See Access
privileges
Retrieving data from other files.
See Exchanging files
Reverting
find requests 3-6
records 2-7
Right-click menus. See Context
menus 1-5
Rights. See Access privileges
RMI format 2-12
Rotating objects 7-18
Rounded rectangle tool 7-14
Rows
in Excel import 12-4
in portals 6-20
Rows, in ODBC tables 15-1
Ruler lines
described 7-20
setting units 7-20
showing/hiding 7-20
Rulers
graphic 7-20
lines 7-20
setting units 7-20
showing/hiding 7-20
text 7-12
Running scripts 10-2
S
Saving
data automatically A-3
setting preference for A-3
shared files 13-2, 13-4
Scientific notation in number
fields 6-23
Script menu
adding items 10-5, 10-10
deleting items 10-10
reordering items 10-11
Script specifications. See Scripts,
settings
Script steps
adding 10-4
deleting 10-4
described 10-6
for related fields 10-6
italicized 10-10
OLE objects 10-8
options 10-4, 10-6
reordering 10-4, 10-10
ScriptMaker
examples 10-13
steps 10-6
Scripts
adding
comments 10-9
menu items 10-5, 10-10
remarks 10-9
automatically performing A-5