single criteria 89 Relationships graph creating relationships 94 described 87

Single criteria 89 relationships graph creating

This preview shows page 142 - 144 out of 144 pages.

single-criteria 89 Relationships graph creating relationships 94 described 87 , 88 text notes in 94 Repeating find requests 31 Report layouts 58 Reports See also Layouts; Subsummaries creating 54 database 134 previewing 34 records in columns 63 with grouped data 35 , 58 Retrieving data from other files. See Exchanging files Reverting find requests 32 Rulers, showing and hiding 69 Runtime application, compared to FileMaker Pro 126 Runtime solutions creating 125 documenting 126 preparing files 125 updating 128 upgrading 126 S Saving data automatically 17 files 17 found set as snapshot link 11 shared files 99 to Excel and PDF formats 109 Scatter charts 82 Schemas, database, documenting 134 Screen stencils 70 Script triggers 11 Scripts 11 Secondary files. See Relational databases Security, file network guidelines 122 operating system guidelines 121 planning 114 , 121 Selecting fields 24 , 71 files in Launch Center 15 objects 71 records 21 text 71 Selection tool 71 Self-joins 93 Server. See Host; FileMaker Server Settings. See Preferences
Image of page 142
143 Shared files See also Networks accounts 115 clients 99 host 99 limitations 98 on web 109 privilege sets 115 saving 99 setting up privileges for 111 Shortcut menus, choosing from 13 Simple Mail Transfer Protocol (SMTP), sending email through 109 Single-page form layout. See Table View Slide controls 66 Snapshot links, saving and sending found set as 11 , 29 Solutions See also Databases; Files; Runtime solutions creating from Starter Solution 41 creating new 42 described 8 opening in Launch Center 15 publishing on web 109 Sorting records described 33 in Table View 27 related 95 Sound files 44 Source file (relationships) 87 Source table (relationships) 87 Stacked bar charts 81 Stacked column charts 81 Starter Solutions, designing solutions with 8 Statistics, database 134 Status toolbar 18 , 66 Storage options for container fields 51 Stored results 51 , 52 Structure, database 134 Styles, setting for objects, parts, layout background 61 Subforms. See Portals Subsummaries See also Reports; Summary fields creating reports 58 parts, described 80 printing 34 , 35 Subtotals. See Subsummaries; Summary fields Summary fields creating 49 described 44 , 49 dynamic reports in Table View 49 on layouts 80 Summary parts. See Subsummaries Supplemental fields 50 Symbols, and field names 43 T Tab controls 66 Tab order 24 Tabbing into fields 24 Table View 19 adding records 27 changing column order and size 26 copying records 27 creating quick charts 27 defining fields in 47 defining summary fields 49 deleting records 27 described 20 duplicating records 27 dynamic reports in 27 , 49 sending email messages based on record data 27 sorting records 27 working with data and records in 26 , 27 Tables defining 53 described 14 importing data into new 104 naming 53 table occurrences 88 Tabs inserting in fields 25 setting position and alignment 77 Tab-separated text format 103 Testing solutions 127 Text See also Fields aligning with checkboxes and radio buttons 77 attributes 76 changing color 77 fields 44 formatting 76 highlighting 77 rotating Asian text 77 selecting 71 Text baselines, specifying options for 77 Text fields described 44
Image of page 143
Image of page 144

You've reached the end of your free preview.

Want to read all 144 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture