Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now

Relational Database Design with FileMaker Pro

with Cris Ippolite

Video: Relational Database Design with FileMaker Pro: Welcome

- Hi, I'm Cris Ippolite, and this is Relational Database Design for FileMaker Pro. In this course, I'll discuss the concepts and techniques that you can use to design a Relational Database in FileMaker. Using real-world examples, I'll show you how to determine which tables you need to define in your Relationship Graph, as well as how and why to resolve those pesky Many to Many Relationships. I'll explain how to use Relationships in your Scripts and Calculations, and I'll also show you how to use Portals, Filtered Portals, and Related Fields in your layouts.
Expand all | Collapse all
  1. 5m 8s
    1. Welcome
      42s
    2. Why relational databases?
      3m 22s
    3. Using the exercise files
      1m 4s
  2. 11m 12s
    1. Introduction to data modeling
      2m 43s
    2. Reviewing relationships types
      3m 30s
    3. Diagramming relationships
      4m 59s
  3. 12m 10s
    1. Understanding problems caused by many-to-many relationships
      5m 26s
    2. Adding a join table
      6m 44s
  4. 4m 54s
    1. Using primary and foreign key fields
      2m 28s
    2. Determining which tables need keys
      2m 26s
  5. 14m 48s
    1. Defining tables
      2m 47s
    2. Defining key fields
      7m 59s
    3. Introducing the Relationship Graph
      4m 2s
  6. 34m 5s
    1. Understanding related fields
      9m 10s
    2. Understanding portals
      8m 2s
    3. Using relationship options to create related fields
      4m 33s
    4. Using multiple match fields in one relationship
      12m 20s
  7. 16m 24s
    1. Donations example
      5m 11s
    2. Class enrollment example
      6m 9s
    3. Personnel management example
      5m 4s
  8. 44m 45s
    1. Using global fields to filter portals
      9m 50s
    2. Using global fields to create a date range filter
      8m 3s
    3. Using relationships in a script to navigate
      7m 12s
    4. Using portals to connect to data more than one table away
      4m 17s
    5. Creating self-relationships
      6m 56s
    6. Adding charts with related data to layouts
      8m 27s
  9. 16m 52s
    1. Creating aggregate functions using relationships
      9m 48s
    2. Using the List function
      7m 4s
  10. 28s
    1. Next steps
      28s

please wait ...
Watch the Online Video Course Relational Database Design with FileMaker Pro
2h 40m Intermediate Aug 04, 2011 Updated May 12, 2015

Viewers: in countries Watching now:

Let author Cris Ippolite show you how to translate aspects of the real world into the form and language of a relational database, using three practical data modeling examples. The course begins by reviewing some of the basic concepts of data modeling, introducing tables, key fields, and the Relationship Graph. Then, after demonstrating how to establish relationships in a database, the course concludes with a demonstration of some advanced modeling techniques, such as filtering, scripting, and the use of portals.

The course applies to versions of FileMaker Pro from 7 through the most current version.

Topics include:
  • Reviewing relationships types
  • Diagramming relationships
  • Resolving many-to-many relationships
  • Determining which tables need key fields
  • Defining tables in FileMaker Pro
  • Using the Relationship Graph
  • Using multiple match fields in one relationship
  • Using global fields to filter portals
  • Creating self relationships
  • Creating aggregate functions using relationships
Subjects:
Business IT
Software:
FileMaker Pro
Author:
Cris Ippolite

Welcome

- Hi, I'm Cris Ippolite, and this is Relational Database Design for FileMaker Pro. In this course, I'll discuss the concepts and techniques that you can use to design a Relational Database in FileMaker. Using real-world examples, I'll show you how to determine which tables you need to define in your Relationship Graph, as well as how and why to resolve those pesky Many to Many Relationships. I'll explain how to use Relationships in your Scripts and Calculations, and I'll also show you how to use Portals, Filtered Portals, and Related Fields in your layouts.

And now, it's time for us to dive into Relational Database Design with FileMaker Pro.

Find answers to the most frequently asked questions about Relational Database Design with FileMaker Pro .


Expand all | Collapse all
please wait ...
Q: The exercise files for this course do not work on a Mac. It downloads executable files. Can you provide a workaround?
A: The files provided for this course were made pre-FileMaker Pro 12. The system does not recognize the .fp7 files immediately as something that can be opened with FileMaker Pro 12 and instead shows them as Unix Executable Files.

The solution is quite simple. Just double-click the file, at which point the Mac will prompt you to choose an application to open the
file with. Select FileMaker Pro 12 and it will then convert the file from a .fp7 file into the new FileMaker Pro 12 file format, which is .fmp12.
Q: This course was updated on 5/12/2015. What changed?
A: We moved a video from the "Using Relationships" chapter of FileMaker Pro 13 Essential Training into this course, where it will remain evergreen.
 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

* Estimated file size

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Relational Database Design with FileMaker Pro.

Return to your organization's learning portal to continue training, or close this page.


OK

Upgrade to View Courses Offline

login

With our new Desktop App, Annual Premium Members can download courses for Internet-free viewing.

Upgrade Now

After upgrading, download Desktop App Here.

Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Start your FREE 10-day trial

Begin learning software, business, and creative skills—anytime,
anywhere—with video instruction from recognized industry experts.
lynda.com provides
Unlimited access to over 4,000 courses—more than 100,000 video tutorials
Expert-led instruction
On-the-go learning. Watch from your computer, tablet, or mobile device. Switch back and forth as you choose.
Start Your FREE Trial Now
 

A trusted source for knowledge.

 

We provide training to more than 4 million people, and our members tell us that lynda.com helps them stay ahead of software updates, pick up brand-new skills, switch careers, land promotions, and explore new hobbies. What can we help you do?

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.