Default layouts layout 1 comm 205 introduction to

Default Layouts – Layout #1
COMM 205 - Introduction to FileMaker Pro © 2019 – Y.M. Cheung
Default Layouts – Layout #2
18
Form View
Display One Record at a Time
List View
Display Records in a List
Table View
Display Records in a Table
COMM 205 - Introduction to FileMaker Pro © 2019 – Y.M. Cheung
Manage Database  Tables
19
Category Table
COMM 205 - Introduction to FileMaker Pro © 2019 – Y.M. Cheung
Manage Database  Fields and
Relationships
20
Fields in the Category Table Relationships Graph
COMM 205 - Introduction to FileMaker Pro © 2019 – Y.M. Cheung


Importing Data
© 2019 – Y.M. Cheung 21 COMM 205 - Introduction to FileMaker Pro
Data File Formats

FileMaker Pro can handle many different file
formats, e.g. Excel file (.xlsx), Comma-
separated values file (.csv or .txt)

FileMaker Pro can load the data directly into
its tables. You can:

add new records from the source file

update existing records with data from the
source file
© 2019 – Y.M. Cheung COMM 205 - Introduction to FileMaker Pro 22
Import Records
© 2019 – Y.M. Cheung COMM 205 - Introduction to FileMaker Pro 23
FileMaker Pro 17 –
Import Field Mapping
© 2019 – Y.M. Cheung COMM 205 - Introduction to FileMaker Pro 24

Use this dialog box to tell FileMaker Pro what data to import
and where to put it.
Source
Target
Source
Fields
Target
Fields
Field
Mapping
Don’t import first
record (contains field
names)
Import
Actions

FileMaker Pro 18 –
Import Field Mapping
© 2019 – Y.M. Cheung COMM 205 - Introduction to FileMaker Pro 25
Source
Fields
Target
Fields
Source
Target
Use as
Field
Names
Create Relationship
© 2019 – Y.M. Cheung COMM 205 - Introduction to FileMaker Pro 26

Creating Layouts and Portals
© 2019 – Y.M. Cheung